List Info

Thread: NXQL syntax




NXQL syntax
country flaguser name
Belgium
2007-02-21 09:15:43
Hi,

what should the NXQL query to search document in a specific
folder ? 
(like SELECT * FROM document WHERE ecm:path STARTSWITH
"/My domain/My 
Workspace/Folder1/Folder2")

_______________________________________________
ECM mailing list
ECMlists.nuxeo.com
http://li
sts.nuxeo.com/mailman/listinfo/ecm

Re: NXQL syntax
country flaguser name
France
2007-02-21 10:02:52
Vincent Dutat a écrit :
> Hi,
> 
> what should the NXQL query to search document in a
specific folder ?
> (like SELECT * FROM document WHERE ecm:path STARTSWITH
"/My domain/My
> Workspace/Folder1/Folder2")

ecm:path is not based on dc:title but on relative ids of the
documents:

SELECT * FROM document WHERE ecm:path STARTSWITH
"/id_of_My domain/id_of_My
Workspace/id_of_Folder1/id_of_Folder2

-- 
Olivier




_______________________________________________
ECM mailing list
ECMlists.nuxeo.com
http://li
sts.nuxeo.com/mailman/listinfo/ecm

[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )