Menu

OQL Statement Sorting - order by

Zwettler
2022-08-02
2022-08-02
  • Zwettler

    Zwettler - 2022-08-02

    I'm wondering how to order the result of a OQL like

    SELECT Person AS B WHERE B.status = 'active' order by B.[FIELD]
    

    it leads to error: Unexpected token NAME, found 'order'

    I would need this for crating a dashboard.

    kind regards,
    G.H.

     
  • Vincent @ Combodo

    There is no ordering possibility in OQL.
    The Dashlet using the OQL may force an order, such as the Dashlet list can be ordered by the user
    The dashlet GroupBy can also order its results

     
    👍
    1

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.