Hi Vincent, Vincent Dutat wrote: > 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]
You got a small typo :
ecm:currentLifeCycleState
Cheers,
J.
> _______________________________________________
> ECM mailing list
> [email protected]
> http://lists.nuxeo.com/mailman/listinfo/ecm
>
--
Julien Anguenot | Nuxeo R&D (Paris, France)
Open Source ECM - http://www.nuxeo.com
Nuxeo 5 : http://www.nuxeo.org
Mobile: +33 (0) 6 72 57 57 66
signature.asc
Description: OpenPGP digital signature
_______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm
