Hi All! I can not find how to use complex type fields in NXQL queries :( I'll very appreciate any help in this area.
In more details: - I need to have Contact document type which has the list of addresses. - Also, it would be nice to search for Contact by it's address. - Also, it is possible that we will need to have possibility to search for all documents which have address with some criteria (NXQL work nice for polymorphic queries if different documents reuse some schema "select * from Document where reused_schema_prefix:fields_name='pattern'"; but it does not work for complex types "sub-documents"). I have the following XSD: <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"; targetNamespace="http://.../contact"; xmlns:tns="http://.../contact"; /> <xs:complexType name="address"> <xs:sequence> <xs:element name="street" type="xs:string" /> <xs:element name="city" type="xs:string" /> ... </xs:sequence> </xs:complexType> ... <xs:complexType name="contact_addresses"> <xs:sequence> <xs:element name="contact_address" type="tns:address" ... /> </xs:sequence> </xs:complexType> ... <xs:element name="contact_addresses" type="tns:contact_addresses" /> </xs:schema> Nuxeo store XSD complexType "address" as sub-document (record in dedicated table "address" + record in "hierarchy" table with "isproperty=true" flag). When I try to search something using NXQL syntax: <select * from Document where address:city = 'my native city'>, Nuxeo recognize "address:cit" field, and join "address" table properly with correct predicate, but it additionally checks if "hierarchy.primarytype" value equals to one of registered core type (address is not core type in my case, it is field). So, as result, Nuxeo can not find my contact by its address :( Is there are any other way to map collection of complex type (more then one primitive field where xsd list works fine) and have possibility to search document by it's complex type fields? P.S. I've read related nuxeo-book chapters and QueryTestCase.java sources. It did not help me in this case :( Best regards, Alexader Litvin. -- Posted by "alexander.litvin" at Nuxeo Discussions <http://nuxeo.org/discussions> View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=3265#9786> _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
