In NXQL today you cannot query complex properties, sorry. You can follow https://jira.nuxeo.org/browse/NXP-4464 but the work on this is not scheduled yet.
Florent On Tue, Dec 15, 2009 at 9:54 AM, Jose Maria Muñoz Peinador <[email protected]> wrote: > Hi, > > > > I’m trying to get complexType working with a database query but I only can > use simpleType.I don’t know how to do a query using complexTypes in Nuxeo > database. > > > > In other words: > > > > I can ask by “reg:num_reg” using query > > > > SELECT * FROM databasereg WHERE reg:num_reg LIKE '11111111'; > > > > And I obtain my response (XML below): > > > > <documents> > > <document> > > <system> > > <type>DatabaseReg</type> > > </system> > > <schema xmlns:rege="..." name="databasereg"> > > <rege:people> > > <item> > > <cod>123456</cod> > > </item> > > <item> > > <cod>789012</cod> > > </item> > > </rege:people> > > </schema> > > <schema xmlns:reg="..." name="regcommon"> > > <reg:num_reg>11111111</reg:num_reg> > > </schema> > > <schema xmlns:dc="..." name="dublincore"> > > ... > > </schema> > > <schema xmlns="..." name="common"> > > ... > > </schema> > > <reg_jus xmlns:xalan="..."> > > <data1> > > <num_reg>11111111</num_reg> > > </data1> > > <data2> > > <data3> > > <people> > > <cod>123456</cod> > > </people> > > </data3> > > </data2> > > </reg_jus> > > </document> > > </documents> > > > > So, How I can obtain the same but asking by parameter “cod” (complexType)?. > I mean, How it was the query where complextype “cod” was like 123456? > > > > Thanks a lot. > > > > > > > ------------------------------------------------------------------ > 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 > > -- Florent Guillaume, Director of R&D, Nuxeo Open Source, Java EE based, Enterprise Content Management (ECM) http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87 _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
