Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-16557

Add helper to CurrentDate for NXQL query

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Reopened
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 6.0-HF05, 7.1
    • Fix Version/s: None
    • Component/s: Automation
    • Tags:
    • Story Points:
      3

      Description

      As of today, using the CurrentDate wrapper in NXQL queries is not completely straightforward and error prone.

      Select * From Document Where dc:created < DATE '@{CurrentDate.format("yyyy-mm-dd")}'
      

      or

      Select * From Document Where dc:created < TIMESTAMP '@{CurrentDate.format("what is the correct format ?")}'
      

      Would be a lot easier and faster if there were helpers so that you don't need to ask yourself what is the correct format.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: