Index ArticlesGetting Started Overview Installation What’s new? Known limitations Data Explorer Database administration Data administration Remote database connections Table settings Media library integration Add CRUD forms Export and import Import CSV file Export table settings Data Backup Transfer to other WP database Data Publisher Quick tour Roadmap Setup and use the Data Publisher Non admin user access Responsive publications Adding filters Advanced settings Hyperlinks Shortcode usage Styling a publication Data Projects Quick tour Overview 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 Styling a project page 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 Advanced Search [Premium] Advanced search overview 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 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.