Hi, I have two custom doctypes with common properties (both have a registry number, for example), and I'm customizing the advanced search to be able to search using those common properties:
<predicate parameter="re:reg_number" operator="="> <field schema="regsearch" name="reg_number" /> </predicate> <predicate parameter="rs:reg_number" operator="="> <field schema="regsearch" name="reg_number" /> </predicate> The problem is, those two predicates are joined by an AND, so the query never returns any results: [QueryModelDescriptor] SELECT * FROM Document WHERE re:reg_number = '0001' AND rs:reg_number = '0001' Is there a way to group those two predicates with an OR? [QueryModelDescriptor] SELECT * FROM Document WHERE (re:reg_number = '0001' OR rs:reg_number = '0001') If there isn't, how could I approach this problem? Thank you. Daniel Pérez Álvarez Technological Solutions Atos Origin +34 91 126 7290 C/ Albasanz, 16 28037 Madrid Spain ------------------------------------------------------------------ This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Origin group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. Este mensaje y los ficheros adjuntos pueden contener informacion confidencial destinada solamente a la(s) persona(s) mencionadas anteriormente pueden estar protegidos por secreto profesional. Si usted recibe este correo electronico por error, gracias por informar inmediatamente al remitente y destruir el mensaje. Al no estar asegurada la integridad de este mensaje sobre la red, Atos Origin no se hace responsable por su contenido. Su contenido no constituye ningun compromiso para el grupo Atos Origin, salvo ratificacion escrita por ambas partes. Aunque se esfuerza al maximo por mantener su red libre de virus, el emisor no puede garantizar nada al respecto y no sera responsable de cualesquiera danos que puedan resultar de una transmision de virus. ------------------------------------------------------------------ _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
