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

Add NOW() function and related date computations to NXQL

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Query & PageProvider

      Description

      In NXQL it's often useful to be able to compute TIMESTAMP values from the current date.

      Suggested syntax:

      SELECT * FROM ... WHERE dc:created < NOW()

      The NOW() function could take a string argument to represent a time duration to add/substract to the current date, like NOW('-P2DT3H4M'), based on the Duration.parse method (or the one in Period if there is no time component maybe?).

        Attachments

          Issue Links

          duplicates

          Improvement - An improvement or enhancement to an existing feature or task. NXP-26305 Add a NOW expression in NXQL

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. NXP-16557 Add helper to CurrentDate for NXQL query

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Reopened

            Activity

              People

              • Assignee:
                fguillaume Florent Guillaume
                Reporter:
                fguillaume Florent Guillaume
                Participants:
              • Votes:
                2 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: