Hi,
can you try the following where clause :
... jd:publishedDate >= TIMESTAMP '1700-01-01 00:00:00' AND
jd:publishedDate <= TIMESTAMP '2009-05-20 17:23:07' ...
[email protected] wrote:
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
--
Vincent Dutat
for any given software, the moment you manage to master it, a new
version appears.
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
