We are using Nuxeo 5.2.0-rc1 and have a nxql query which restricts content based on a published date.
This date is stored defined like this <xs:element name="publishedDate" type="xs:date" /> and appears to be being stored properly. I am able to use this date in the following way to restrict content based on the published date being in the past if I do something like this. *SELECT * FROM Document WHERE ((ecm:currentLifeCycleState='approved' AND (ecm:primaryType='SomeType')) AND jd:primarySite='some site' AND jd:publishedDate between date '1700-01-01' and date '2009-05-20') ORDER BY jd:publishedDate DESC* This is fine except we want to set the published date to the minute and therefore do a query like this. *SELECT * FROM Document WHERE ((ecm:currentLifeCycleState='approved' AND (ecm:primaryType='SomeType')) AND jd:primarySite='some site' AND jd:publishedDate between date '1700-01-01' and date '2009-05-20 17:23:07') ORDER BY apack:order ASC, jd:publishedDate DESC* Note the hours, minutes and seconds in the query. This produces the following error *Invalid format: "2009-05-20 17:23:07" is malformed at " 17:23:07"* Is there a way of specifying a time as well as a date in a nxql query? I have not been able to find an example in the documentation or forums. Thanks in advance James -- Posted by "williajd" at Nuxeo Discussions <http://nuxeo.org/discussions> View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2463#6718> _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
