Title: Publisher Custom Query
Last modified: April 2, 2022

---

# Publisher Custom Query

 *  Resolved [Steve Fulton U.E](https://wordpress.org/support/users/ogs2017/)
 * (@ogs2017)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/publisher-custom-query/)
 * Hi Peter
 * Thought I would ask this here to document it for others.
 * I have been exploring and experimenting with the Custom Query in Publisher. Here
   is the custom query I used:
 * SELECT `firstname`, `lastname` FROM `person` WHERE createTime >= NOW() – INTERVAL
   1 DAY ORDER BY `lastname` DESC
 * I am trying to list on the Webpage the latest 5 records submitted. When I include
   Limit 5 to the SQL Code, I get a Query Error as your code inserts Limit 100 to
   the end of my code.
 * I have tried to insert {“pageLength”: 5} in the Advanced Options but the system
   ignores this.
 * Any incite you may be able to help me with. I have included the website where
   the Table is placed, just scroll down.
 * Thanks
 * Steve Fulton, UE
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fpublisher-custom-query%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/publisher-custom-query/#post-15523846)
 * Hi Steve,
 * Found it and fix it! Hope to release by the end of this week…
 * Thank you for reporting,
    Peter

Viewing 1 replies (of 1 total)

The topic ‘Publisher Custom Query’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [4 years, 3 months ago](https://wordpress.org/support/topic/publisher-custom-query/#post-15523846)
 * Status: resolved