Thanks Skip, This works for single-value properties, but not for my multi-value properties. Any Ideas?
Dieter Magnolia - User mailing list wrote: > > > This works for me... > > > //element(*, nodeType) [EMAIL PROTECTED] = 'propertyValue'] > > for example: > > //element(*, nt:unstructured) [EMAIL PROTECTED] = 'salesDollars'] > > > Hope this works, > > Skip > > > > > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] > Sent: Friday, April 27, 2007 7:43 AM > To: [email protected] > Subject: Re: [magnolia-user] Sql Queries on select control type > > > > Well i actually found some assistance on the JCR forum for this, but i am > still having no luck which is quite irritating as they seem convinced it > should work. > > //[EMAIL PROTECTED] = 'News'] should be the right solution? I have gone > through the entire specification documentation and am now at wits end. > > Can anybody please help!! > > Dieter > > > dieter wrote: >> >> Hi, >> I am trying to run a query on a news item where i have assigned one or >> many categories. The categories are assigned in a dialog and use a >> checkbox control to be assigned. >> >> Now i understand how simple queries work as in the sample, but how do i >> query a multiselect value as in my example above. >> >> When i looked in the exported xml, it is stored as a node instead of a >> property (as other standard text entry items are). >> >> <sv:node sv:name="pageCategory"> >> <sv:property sv:name="jcr:primaryType" sv:type="Name"> >> <sv:value>mgnl:contentNode</sv:value> >> </sv:property> >> <sv:property sv:name="jcr:mixinTypes" sv:type="Name"> >> <sv:value>mix:versionable</sv:value> >> </sv:property> >> <sv:property sv:name="jcr:uuid" sv:type="String"> >> <sv:value>a6f7ba18-aec8-4d39-b43f-7f9b7e387408</sv:value> >> </sv:property> >> <sv:property sv:name="0" sv:type="String"> >> <sv:value>news</sv:value> >> </sv:property> >> <sv:node sv:name="MetaData"> >> <sv:property sv:name="jcr:primaryType" sv:type="Name"> >> <sv:value>mgnl:metaData</sv:value> >> </sv:property> >> <sv:property sv:name="jcr:uuid" sv:type="String"> >> <sv:value>4e563fc3-3e72-4bc3-ab34-5f932b0af9ff</sv:value> >> </sv:property> >> <sv:property sv:name="mgnl:creationdate" sv:type="Date"> >> <sv:value>2007-04-26T12:38:16.443+01:00</sv:value> >> </sv:property> >> </sv:node> >> </sv:node> >> >> >> Thanks, >> >> Dieter >> > > -- > View this message in context: > http://www.nabble.com/Sql-Queries-on-select-control-type-tf3651160.html#a10220164 > Sent from the Magnolia - User mailing list archive at Nabble.com. > > > ---------------------------------------------------------------- > for list details see > http://www.magnolia.info/en/developer.html > ---------------------------------------------------------------- > > ---------------------------------------------------------------- > for list details see > http://www.magnolia.info/en/developer.html > ---------------------------------------------------------------- > > -- View this message in context: http://www.nabble.com/Sql-Queries-on-select-control-type-tf3651160.html#a10249598 Sent from the Magnolia - User mailing list archive at Nabble.com. ---------------------------------------------------------------- for list details see http://www.magnolia.info/en/developer.html ----------------------------------------------------------------
