Title: marcodisco's Replies | WordPress.org --- # marcodisco [ ](https://wordpress.org/support/users/marcodisco/) * [Profile](https://wordpress.org/support/users/marcodisco/) * [Topics Started](https://wordpress.org/support/users/marcodisco/topics/) * [Replies Created](https://wordpress.org/support/users/marcodisco/replies/) * [Reviews Written](https://wordpress.org/support/users/marcodisco/reviews/) * [Topics Replied To](https://wordpress.org/support/users/marcodisco/replied-to/) * [Engagements](https://wordpress.org/support/users/marcodisco/engagements/) * [Favorites](https://wordpress.org/support/users/marcodisco/favorites/) Search replies: ## Forum Replies Created Viewing 6 replies - 1 through 6 (of 6 total) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Trying to make dynamic filters](https://wordpress.org/support/topic/trying-to-make-dynamic-filters/) * Thread Starter [marcodisco](https://wordpress.org/support/users/marcodisco/) * (@marcodisco) * [5 years, 10 months ago](https://wordpress.org/support/topic/trying-to-make-dynamic-filters/#post-13180873) * Hi Peter, * I did send you the details for access to my site via the contactform on you plugin page. * Please ignore the issue that I mentioned about not being able to update records– that was caused by DB access permissions and is resolved. * Thanks for your help, once again. You are the most responsive plugin author. It makes me re-think about publishing my own plugins, if I have to live up to this level of support 🙂 * The only things that I have as still an issue are 1) using the wpda_search_column as a GET query variable against a Data Project page – the filter is lost if I click on column headers to re-order data. 2) just being able to set an order_by in an option set used by a Data Project page. I have tried this using a SQL-style entry ‘report_time desc’, and no good. I tried the same format as works in a Data Publication i.e. ‘2, desc’ but that didn’t seem to work either. * Finally, what DB GRANTs are required for target Database? My example DB (not the WordPress DB) only uses wp data access for reads and updates, so I have granted only select and update access. Is that enough? * Any insights would be appreciated. * Thanks, Mark * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Trying to make dynamic filters](https://wordpress.org/support/topic/trying-to-make-dynamic-filters/) * Thread Starter [marcodisco](https://wordpress.org/support/users/marcodisco/) * (@marcodisco) * [5 years, 10 months ago](https://wordpress.org/support/topic/trying-to-make-dynamic-filters/#post-13176003) * Hi Peter, * Thanks, * Yes, you were quite correct – wpda_search_column IS working for a Data Publication now, I just needed to reload the page without cache to get latest javascript. Also, I note that sorting by column in the broweser/client works nicely here. * I will send the access details for my site via the contact form in case you would find it helpful. * Kind regards, Mark * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Trying to make dynamic filters](https://wordpress.org/support/topic/trying-to-make-dynamic-filters/) * Thread Starter [marcodisco](https://wordpress.org/support/users/marcodisco/) * (@marcodisco) * [5 years, 10 months ago](https://wordpress.org/support/topic/trying-to-make-dynamic-filters/#post-13174631) * Hi Peter, * Thanks for your work here, but I don’t have any good news. I de/re-installed your pluging from WordPress following your instructions. * I tried wpda_search_column as a query variable against a Data Publication but it still didn’t work for me. * Also I noticed that when I used wpda_search_column in a Data Project page, all worked, but then as soon as I do something like re-order the data by clicking a column header, the filter is lost. I needed to re-order as the order that I specified in the Data Project option group itself didn’t work. * Kind regards, Mark * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Trying to make dynamic filters](https://wordpress.org/support/topic/trying-to-make-dynamic-filters/) * Thread Starter [marcodisco](https://wordpress.org/support/users/marcodisco/) * (@marcodisco) * [5 years, 10 months ago](https://wordpress.org/support/topic/trying-to-make-dynamic-filters/#post-13172377) * Hi Peter, * Thanks for your notes. * Step 2 – id_artist is an INT field. Yes, the shortcode is the same. As yours works, I tried removing some of the settings in my publication (field list, ORDER by), but still no luck. * Step 3 – OK, yes, using the wpda_search_column query variable against a page created from a Data Project DOES WORK!! I set up the dynamic hyperlink to point to a page with a shortcode like [wpdadiehard project_id=”1″ page_id=”3″] and now my View Tracks against each Artist works fine. * That should be enough for me to complete my proof-of-concept site for now. * Thanks, Mark * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Data Publisher page using high CPU & unresponsive](https://wordpress.org/support/topic/data-publisher-page-using-high-cpu-unresponsive/) * Thread Starter [marcodisco](https://wordpress.org/support/users/marcodisco/) * (@marcodisco) * [5 years, 10 months ago](https://wordpress.org/support/topic/data-publisher-page-using-high-cpu-unresponsive/#post-13172089) * OK, that makes sense. * Thanks Peter. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Data Publisher page using high CPU & unresponsive](https://wordpress.org/support/topic/data-publisher-page-using-high-cpu-unresponsive/) * Thread Starter [marcodisco](https://wordpress.org/support/users/marcodisco/) * (@marcodisco) * [5 years, 10 months ago](https://wordpress.org/support/topic/data-publisher-page-using-high-cpu-unresponsive/#post-13171803) * Thanks for the quick response Peter. * I understand what you have said, and see that I have a way to make the list responsive. * From a technical standpoint, I don’t see why the number of records in my DB table should affect your page which is essentially a list of what is in your plugins publication table. * Regards, Mark Viewing 6 replies - 1 through 6 (of 6 total)