Posted a reply to Error in SQL syntax at import csv file, on the site WordPress.org Forums:
Hi Pieter, It is not possible to create CPT's from a CSV file. You can…

Posted a reply to Error UPD-0 while mapping, on the site WordPress.org Forums:
Hi Marshall, Did you make any progress with this issue? Can I close it? Thanks,…

Posted a reply to Order publication by a table field that I don’t want to display, on the site WordPress.org Forums:
Hi Martin, Did you make any progress with this issue? Can I close it? Thanks,…

Posted a reply to Family users, on the site WordPress.org Forums:
Hi Ben, Did you make any progress with this issue? Can I close it? Thanks,…

Posted a reply to Code Manager shows and allows 57 liness of PHP code, on the site WordPress.org Forums:
Hi Jim, The issue is fixed! Please update to version 1.0.17. Thank you for reporting…

Posted a reply to database triggers – how use, on the site WordPress.org Forums:
Hi L, I think you can do this with Google Cloud or AWS, but that's…

Posted a reply to Error in SQL syntax at import csv file, on the site WordPress.org Forums:
Hi Pieter, Are you using the latest version of the plugin? If not, can you…

Posted a reply to Error UPD-0 while mapping, on the site WordPress.org Forums:
Hi Marshall, Did you perform and save the column mapping? Is it saved correctly? You…

Posted a reply to Code Manager shows and allows 57 liness of PHP code, on the site WordPress.org Forums:
Sorry James! Here is de link: https://code-manager.com/code/?wpda_search_column_code_name=Code-Manager-Publication-Layout-Panel Best regards, Peter

Posted a reply to database triggers – how use, on the site WordPress.org Forums:
That's bad! Nothing you can do against missing privileges. SSL won't solve this. Switching to…

Posted a reply to Order publication by a table field that I don’t want to display, on the site WordPress.org Forums:
Hi Martin, >>> Is there a way I can prevent it from appearing underneath /…

Posted a reply to Code Manager shows and allows 57 liness of PHP code, on the site WordPress.org Forums:
Hi James, The Code Manager basically supports un unlimited number of code lines per snippet.…

Posted a reply to database triggers – how use, on the site WordPress.org Forums:
Hi L, Did you execute the code? Or just save it? When you copy this…

Posted a reply to Order publication by a table field that I don’t want to display, on the site WordPress.org Forums:
Hi Martin, It is generally not possible to order on columns that are not selected…

Posted a reply to Is it possible to reference filter_field_value in publication WHERE clause, on the site WordPress.org Forums:
Smart solution Martin! 💪 Great! Thanks for reporting back, Peter

Posted a reply to WPDA: QUERY and $$USER$$ variable, on the site WordPress.org Forums:
Yes Rahim, It is fixed! Let me know if there are still other issues... Best…

Posted a reply to Is it possible to reference filter_field_value in publication WHERE clause, on the site WordPress.org Forums:
Hi Martin, The filter_field_name / filter_field_value pair is used for safe variable binding. This is…

Posted a reply to Publication Search Panes, on the site WordPress.org Forums:
👍 Let me know if you need help Mark! Best regards, Peter

Posted a reply to Publication Search Panes, on the site WordPress.org Forums:
Hi Mark, The problem is this option: No search condition = show no rows Search…

Posted a reply to How to use rdb: SSL connection?, on the site WordPress.org Forums:
Hi @rlohmj, Using SSL involves several steps. I would start to connect without SSL first.…

Posted a reply to Family users, on the site WordPress.org Forums:
Hi Ben, I can't tell if you're on the right track with those posts, but…

Posted a reply to How to create search form, on the site WordPress.org Forums:
Fair enough, I see the need! Here is a demo: https://wpdataaccess.com/publication-search-form-demo/ The demo contains a…

Posted a reply to How to create search form, on the site WordPress.org Forums:
Hi @sp4448, There are multiple ways to add interactive filtering. You can find the documentation…

Posted a reply to Family users, on the site WordPress.org Forums:
Hi Ben, Interesting use case! 😊 Since you only have one user id per user…

Posted a reply to How to convert unix timestamp to date/time, on the site WordPress.org Forums:
Hi Josh, Thanks your reporting back! I think I know why the formatting did not…

Posted a reply to How to convert unix timestamp to date/time, on the site WordPress.org Forums:
Hi Josh, You can use function from_unixtime: SELECT from_unixtime(wp_wise_chat_messages.time`) as 'Time' , wp_wise_chat_messages.user as 'User'…

Posted a reply to How to convert unix timestamp to date/time, on the site WordPress.org Forums:
Hi Josh, Good question! I never thought of this... Unfortunately, the Visual Query Builder does…

Posted a reply to Can a publication receive a URL parameter from a WP rewrite, on the site WordPress.org Forums:
Great! 😊 Thanks for reporting back 👍

Posted a reply to Can a publication receive a URL parameter from a WP rewrite, on the site WordPress.org Forums:
Hi Martin, Just write the value to your shortcode call. Something like this: $series_id =…

Posted a reply to Can a publication receive a URL parameter from a WP rewrite, on the site WordPress.org Forums:
Hi Martin, The Data Publisher takes it's URL arguments from the query string. Your rewrite…

Posted a reply to Lookup field displaying on data entry but not list table, on the site WordPress.org Forums:
Hi @lrydant, >>> I’ve shared images. Can you please share the link here? Or use…

Posted a reply to Lookup field displaying on data entry but not list table, on the site WordPress.org Forums:
Hi @lrydant, You can use this website to share images: https://imgbb.com/ Thanks, Peter

Posted a reply to Lookup field displaying on data entry but not list table, on the site WordPress.org Forums:
What if you select another column to be shown in your lookup? Can you share…

Posted a reply to Lookup field displaying on data entry but not list table, on the site WordPress.org Forums:
Hi @lrydant, >>> I apologize – thought I replied. No problem! Can you please open…

Posted a reply to Can a publication receive a URL parameter and use it in WHERE clause, on the site WordPress.org Forums:
Hi @schoolboy101, Thanks for the compliment! 😊 You can do that with a URL parameter.…

Posted a reply to Lookup field displaying on data entry but not list table, on the site WordPress.org Forums:
Hi @pixw, It this issue still open or can I close it? Thanks, Peter

Posted a reply to Column specific search with sorted listbox, on the site WordPress.org Forums:
Hi @pixw, It this issue still open or can I close it? Thanks, Peter

Posted a reply to WPDA: QUERY and $$USER$$ variable, on the site WordPress.org Forums:
Hi Marco, Environment variables are not available in lookups. Sorry! This requires some changes in…

Posted a reply to WPDA: QUERY and $$USER$$ variable, on the site WordPress.org Forums:
Hi Rahim, Thank for your explanation. 👍 I see the problem! The search panes query…

Posted a reply to WPDA: QUERY and $$USER$$ variable, on the site WordPress.org Forums:
Hi Rahim, Marco, You can use the $$USER$$ variable in a publication just like a…

Posted a reply to Show saved query of Premium Data Publisher on menu, on the site WordPress.org Forums:
Hi Luca, I updated the documentation. You can find the information about shared dashboards here:…

Posted a reply to Show saved query of Premium Data Publisher on menu, on the site WordPress.org Forums:
Hi Luca, Thank you for the detailed explanation! 👍 It is not possible to add…

Posted a reply to Database Trigger message to WPDA, on the site WordPress.org Forums:
Hi Marco, Charles, It is relatively simple to generate an error from a trigger and…