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

Add a NOW expression in NXQL

    Details

    • Release Notes Summary:
      NOW expression is added in NXQL language.
    • Impact type:
      API change
    • Upgrade notes:
      Hide

      NXQL can now use a NOW() function.

      NOW() returns the current date/time.

      NOW(period) returns the current date/time plus the given period. The period is a string expressed in ISO-8601 period format, PnYnMnDTnHnMnS. A leading minus sign, and negative values for the units, are allowed. So for instance:

      • NOW('P1D'): in one day
      • NOW('-P1D'): one day ago
      • NOW('PT1H'): in one hour
      • NOW('P-1DT1H'): one days less one hour ago (usually 23 hours ago, except when DST changes)
      • NOW('P1Y2M3DT4H5M6S'): in one year, two months, three days, four hours, five minutes and six seconds.
      Show
      NXQL can now use a NOW() function. NOW() returns the current date/time. NOW(period) returns the current date/time plus the given period. The period is a string expressed in ISO-8601 period format, PnYnMnDTnHnMnS . A leading minus sign, and negative values for the units, are allowed. So for instance: NOW('P1D') : in one day NOW('-P1D') : one day ago NOW('PT1H') : in one hour NOW('P-1DT1H') : one days less one hour ago (usually 23 hours ago, except when DST changes) NOW('P1Y2M3DT4H5M6S') : in one year, two months, three days, four hours, five minutes and six seconds.
    • Sprint:
      nxFG 11.1.10

      Description

      Add a NOW() and NOW(period) expression to NXQL, so that one can do for example:

      SELECT * FROM Document WHERE ... AND dc:modified < NOW('-P1D')
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 days
                  2d

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.