[JIRA] Commented: (NXP-705) Make dates work in NXQL

Fri, 02 Mar 2007 09:47:12 -0800

Issue (View Online)

Key: NXP-705
Issue Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Florent Guillaume
Reporter: Florent Guillaume

Operations

View all
View comments
View history
Make dates work in NXQL 
Updated: 02/03/07 18:44   Created: 02/03/07 18:43  

The following comment has been added to this issue: [ Permlink ]

Author: Florent Guillaume
Date: 02/03/07 18:44
Comment:
The jackrabbit grammar for that is:
| < DATETIME_LITERAL: <DATE_LITERAL> | <TIMESTAMP_LITERAL> >
| < DATE_LITERAL: "DATE" (" ")+ <DATE_STRING> >
| < TIMESTAMP_LITERAL: "TIMESTAMP" (" ")+ <TIMESTAMP_STRING> >
| < #DATE_STRING: <QUOTE> <DATE_VALUE> <QUOTE> >
| < #TIMESTAMP_STRING: <QUOTE> <DATE_VALUE> (" "|"T") <TIME_VALUE> (<TIME_ZONE_INTERVAL>)? <QUOTE> >
| < #TIME_ZONE_INTERVAL: "Z" | (<SIGN> <HOURS_VALUE> <COLON> <MINUTES_VALUE>) >
| < #DATE_VALUE: <YEARS_VALUE> <MINUS_SIGN> <MONTHS_VALUE> <MINUS_SIGN> <DAYS_VALUE> >
| < #TIME_VALUE: <HOURS_VALUE> <COLON> <MINUTES_VALUE> <COLON> <SECONDS_VALUE> >
| < #YEARS_VALUE: <DATETIME_VALUE> >
| < #MONTHS_VALUE: <DATETIME_VALUE> >
| < #DAYS_VALUE: <DATETIME_VALUE> >
| < #HOURS_VALUE: <DATETIME_VALUE> >
| < #MINUTES_VALUE: <DATETIME_VALUE> >
| < #SECONDS_VALUE: <SECONDS_INTEGER_VALUE> (<PERIOD> (<SECONDS_FRACTION>)?)? >
| < #SECONDS_INTEGER_VALUE: <UNSIGNED_INTEGER> >
| < #SECONDS_FRACTION: <UNSIGNED_INTEGER> >
| < #DATETIME_VALUE: <UNSIGNED_INTEGER> >

Project: Nuxeo Enterprise Platform 5
Components: Query / Search
Affects Versions: 5.0.0 GA, 5.1 M1
Fix Versions: 5.1 M2

 Description   
Date searches currently don't work, for instance
... WHERE dc:created >= DATE '2007-01-01'
or
... WHERE dc:created >= TIMESTAMP '2007-01-01T12:00:00'

This message was automatically generated by Atlassian JIRA Enterprise Edition, Version: 3.7.2-186 - Bug/feature request.
If you think it was sent incorrectly, contact one of this server's administrators. 

_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets

Reply via email to