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 to see the link]

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Publisher Custom Query’ is closed to new replies.