[NXP-26305] Add a NOW expression in NXQL - Nuxeo Issue Tracker

XML

Word

Printable

Release Notes Summary:
NOW expression is added in NXQL language.
Tags:
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

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')

is duplicated by

NXP-22484 Add NOW() function and related date computations to NXQL

is required by

NXP-27435 Record, Retention and Hold low-level implementation

Estimated:

Not Specified

Remaining:

Logged: