Title: filter with wpdataaccess short code
Last modified: November 15, 2019

---

# filter with wpdataaccess short code

 *  Resolved [kirkgroome](https://wordpress.org/support/users/kirkgroome/)
 * (@kirkgroome)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/filter-with-wpdataaccess-short-code/)
 * Hi Peter,
    Is there a way to filter a record set for the user to view only there
   data? Also on a project is there a way to add a custom button on action to a 
   row? Thanks for all your help and your plugin is fantastic. Kirk

Viewing 6 replies - 1 through 6 (of 6 total)

 *  [dsbking](https://wordpress.org/support/users/dsbking/)
 * (@dsbking)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/filter-with-wpdataaccess-short-code/#post-12140136)
 * 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.
 *  [dsbking](https://wordpress.org/support/users/dsbking/)
 * (@dsbking)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/filter-with-wpdataaccess-short-code/#post-12140141)
 * 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?
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/filter-with-wpdataaccess-short-code/#post-12140215)
 * 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/](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](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/](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
 *  Thread Starter [kirkgroome](https://wordpress.org/support/users/kirkgroome/)
 * (@kirkgroome)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/filter-with-wpdataaccess-short-code/#post-12148128)
 * 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
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/filter-with-wpdataaccess-short-code/#post-12151287)
 * 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
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/filter-with-wpdataaccess-short-code/#post-12384314)
 * 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/](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

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘filter with wpdataaccess short code’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 6 replies
 * 3 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [6 years, 4 months ago](https://wordpress.org/support/topic/filter-with-wpdataaccess-short-code/#post-12384314)
 * Status: resolved