Index ArticlesGetting Started Overview Installation Known limitations Updates What’s new? Patches Data Explorer Database administration Data administration Table and view settings Remote database connections Import CSV file Export and import Export table settings Data Backup Transfer to other WP database Data Publisher Getting started Styling publications Styling tutorial Responsive publications Adding filters Advanced search [Premium] Adding hyperlinks Adding buttons [Premium] Custom buttons [Premium] Advanced settings Roadmap Setup and use the Data Publisher Non admin user access Shortcode usage Data Projects Quick tour Overview Styling a project page Registration page One-To-Many relationships Many-To-Many relationships Manage table options Advanced table options Add less/more button Advanced lookups User roles Managing roles and user access Transfer Data Project to other WordPress site Shortcode usage Data Designer Introduction Basic mode Plugin Settings Plugin Back-end Front-end Data Publisher Data Backup Uninstall Manage Repository Manage Roles System Info Shortcodes Which shortcode should I use? Shortcode ‘wpdataaccess’ Styling ‘wpdataaccess’ pages Shortcode ‘wpdadiehard’ Styling ‘wpdadiehard’ pages Premium Features Advanced Search [Premium] Search settings Normal search Full-text search Define queryable columns Individual column search Indexes and performance Inline Editing [Premium] Inline Editing overview Inline Editing in Data Projects Supported column types Code Manager Manage code Share(d) code Write code Was this article helpful to you? Yes 3 No 3 Replies to “Index” Hi, it is possible to publish a query instead of the entire table? I want to show in the linked page anly the events in program, as shown by this query: SELECT * FROM `Eventi` WHERE `Dal` >= NOW( ) Can you help me? Regards Reply Hi Silvio, Adding a where clause to a publication is not yet supported but it is on my to do list. But…you can achieve the same result with a view. You just need to create a view for your query, give access rights to that view in the Front-end Settings and use the view in the Data Publisher in the same way as you would use table Eventi. Hope this helps… Best regards, Peter Reply An excellent instructional experience regarding very helpful features/additions to the already very fine plug-in. Strong work! Thank you very much. Reply Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment Name * Email * Website Save my name, email, and website in this browser for the next time I comment.