I would like to find documents matching a specified docuemnt type and a
current current lifecycle state like this :
SELECT * FROM DossierClient WHERE (ecm:currentLifecycleState='lead')
The query does NOT give me any result even if some documents match the
conditions. Here is a Lucene debug :
2007-06-04 13:27:10,195 DEBUG
[org.nuxeo.ecm.webapp.search.SearchActionsBean] Query: SELECT * FROM
DossierClient WHERE (ecm:currentLifecycleState='lead' )
2007-06-04 13:27:10,242 DEBUG
[org.compass.core.lucene.engine.LuceneSearchEngine] RESOURCE QUERY
[+(ecm:primaryType:DossierClient) +ecm:currentLifecycleState:lead
+builtin_acp_indexed:MatchBefore([+ged#Browse, +members#Browse,
+administrators#Browse, +Everyone#Browse, +ged#Everything,
+members#Everything, +administrators#Everything, +Everyone#Everything,
+ged#Read, +members#Read, +administrators#Read, +Everyone#Read,
+ged#ReadWrite, +members#ReadWrite, +administrators#ReadWrite,
+Everyone#ReadWrite], [-ged#Browse, -members#Browse,
-administrators#Browse, -Everyone#Browse, -ged#Everything,
-members#Everything, -administrators#Everything, -Everyone#Everything,
-ged#Read, -members#Read, -administrators#Read, -Everyone#Read,
-ged#ReadWrite, -members#ReadWrite, -administrators#ReadWrite,
-Everyone#ReadWrite])] HITS [0]
