[NXP-8906] Allow DATE-based comparisons in NXQL - Nuxeo Issue Tracker

XML

Word

Printable

Upgrade notes:

Hide

Now it's possible to make queries like:

SELECT * FROM Document WHERE DATE(dc:modified) = DATE '2012-02-22';

This can be efficient only if the underlying database has a specialized index on the column. For PostgreSQL, the index must be added as:

CREATE INDEX dc_modified_date_idx ON dublincore (DATE(modified))

Show
Now it's possible to make queries like: SELECT * FROM Document WHERE DATE(dc:modified) = DATE '2012-02-22'; This can be efficient only if the underlying database has a specialized index on the column. For PostgreSQL, the index must be added as: CREATE INDEX dc_modified_date_idx ON dublincore (DATE(modified))

We need to be able to do this in NXQL:

SELECT * FROM Document WHERE DATE(dc:modified) = DATE '2012-02-22';

(Also with other comparison operators.)

No date arithmetic (time interval types) are needed for this.

To be efficient ad-hoc functional indexes will have to be added by hand by a DBA (see upgrade notes).