filter with wpdataaccess short code

Do you mean a way to override the “Default pagination value” in the shortcode? That would be awesome if we could do that as it could then be set on a per-data set basis.

Oops! I think I read you comment wrong – half asleep! ??

If you look at the sas data example is uses %%USER%% as a way of showing only the data for specific student, i.e. if they’re logged in it’ll show them only their own courses and grades. Is this what you mean?

Hi Kirk, hi Darren,

There are a number of ways to filter your data. It depend on your goal.
1) If your user has read-only access, you can use a view and add a where clause.
2) If your user has write access, you can use the $$USER$$ and $$USERID$$ environment variables in the where clause of your Data Projects page (see https://wpdataaccess.com/docs/documentation/data-projects/user-roles-and-where-clauses/). If you use shortcode wpdadiehard you can also use the parameters filter_field_name and filter_field_value (see https://wpdataaccess.com/docs/documentation/shortcodes/shortcode-wpdadiehard/#filtering).
Option 2 can be used with views as well.

You can add a hyperlink to a list that is displayed in list tables as well as Data Publications (see https://wpdataaccess.com/docs/documentation/data-explorer/add-hyperlink-to-table-column/). Can you user that feature to add a custom row action? If not, what kind of row action do you need? Can you give an example?

Best regards,
Peter

Hi Peter,
I was looking to filter a publisher not a project. I tried the filtering on the publisher and it did not seem to work. Can you filter the publisher?

Kirk

Hi Kirk,

If you want to filter a table used in the Data Publisher, you can use a view. The plugin does not yet support the creation of views, so you’ll have to write your own script. You can execute your script files from the Data Explorer and then use your view just like you would use a table. Make sure you grant access to the view in the plugin front-end settings, otherwise you’ll not be able to use it. Hope this works for you!

Best regards,
Peter

Hi Kirk,

This topic is an old one, just wanted to let you know that version 3 is out and allows you to add your own search logic to the Data Publisher through a shortcode.

More info can be found here:
https://wpdataaccess.com/2020/01/29/filter-wpda-construct-where-clause-to-add-custom-search-behaviour/

Let me know if you need help.

Best regards,
Peter