What I want to do is search for locked documents in a specific folder that
meet certain other criteria. The folder and matching criteria are simple
enough, but I am not sure how to include a condition to test for a
document lock. I know the lock table holds all the locks and I supposed I
could do the reverse - scan the lock table, determine the parent and see
if it happens to be the specified folder, etc .... but this is (obviously)
not very efficient.
public static final String DOCUMENT_QUERY = "SELECT * FROM Document "
+
"WHERE ecm:isProxy = 0
AND " +
"ecm:currentLifeCycleState != 'deleted' AND " +
"ecm:path STARTSWITH
'%s' AND " +
"dublincore:created <
date '%s' AND " +
"ecm:lock != ''";
I know "ecm:lock" doesn't work, but I am hoping that there is a way to
include a check for lock status in this type of query.
Thanks,
Bruce.
--------------------
metaLogic
ph. +1.905.629.7775 x225
fax +1.905.629.9887
http://metaLogic.ca_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
