marcodisco
Forum Replies Created
-
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,
MarkHi 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,
MarkHi 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,
MarkHi 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,
MarkOK, that makes sense.
Thanks Peter.
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