AnsweredAssumed Answered

NSQL with ORDER / LIMIT?

Question asked by L.Elias Champion on Dec 19, 2014
Latest reply on Dec 30, 2014 by L.Elias

I'm trying to build a query for use potentially in a portlet, but more specifically to be queried externally via XOG. The intent is to return the last 5 status reports for a specific project. I have the overall query working to return the status reports, but am struggling with ordering by date and limiting the result set. So far as I am aware, ORDER BY is not supported in NSQL (v13). I'm not sure about LIMIT but without order it wouldn't be much help alone. Has anyone done anything similar to this? My initial thought would be some sort of nested select/subquery to get the last 5 status report id's specifically but before heading in that direction wanted to see if there was a better way.

Outcomes