Hi Vincent,
Could you check in the logs what query is executed? For instance
(here for a full-text query):
2007-02-28 18:50:03,312 INFO [org.nuxeo.ecm.core.jcr.JCRQuery]
execute XPath query: //element(*, ecmnt:document)[jcr:contains
(.,'*toto*')]
It's possible that there is a bug in the NXQL -> JCR conversion...
Also, what unwanted results do you get?
Florent
On 28 Feb 2007, at 11:27, Vincent Dutat wrote:
Hi,
I am having problems with NXQL when query contains a where-clause
with a date. It looks like the '=' does not work. For example, I
created a document on Feb 20 2007 and the following query does not
work :
SELECT * FROM document WHERE dc:created = "2007-02-20"
But the following one works but it also gives me unwanted results :
SELECT * FROM document WHERE dc:created >= "2007-02-20"
--
Florent Guillaume, Director of R&D, Nuxeo
Open Source Enterprise Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
