Hi David, Thanks for your assistance, it seems you have an understanding of the difficulties i am facing with this. The query you gave me unfortunately returns an error.
//*[pageCategory/@*='news'] Only attribute axis is allowed in predicate I've tried different variations, only for it to return no results like before. Do you have another take on it? Thanks, dieter Magnolia - User mailing list wrote: > > The crux of the problem is how checkbox values are stored. Other > controls simply write a single value to a nodeData and they're done. > For those, expressions like //[EMAIL PROTECTED]'News'] would work. > Checkboxes are different in they write a contentNode and each checked > value is written as a nodeData underneath using the same parlance used > to name paragraphs in a paragraph collection. > > Example: > > myPage > +- pageCategory > +- 0 'Value 1' > +- 1 'Value 2' > +- 2 'Value 5' > +- 3 'Value 8' > > So what we're after for an XPath expression is: > > > //*[pageCategory/@*='News'] > > This returns all nodes containing a pageCategory, further for the set of > all nodes containing a pageCategory, the pageCategory node contained > within must contain at least one nodeData with the value 'News'. To > verify in version 3.0.x, simply take a look at your page in the JCR > Browser and to test the query, drop it in to the query tool to see the > result set. > > Sorry, but I don't know how to do the SQL version of this. > > --David > > > Skip Strickland wrote: >> Dieter, >> >> Can you try the "and" operator? >> >> //element(*, nt:unstructured) [(@title = 'salesDollars') and (@total > >> 1000) ] >> >> Also the "not" operator: >> >> //element(*, nt:unstructured) [(@title = 'salesDollars') and not (@state >> = 'Florida') ] >> >> >> >> Some references I study: >> http://www.w3schools.com/xpath/xpath_syntax.asp (especially helpful) >> http://www.w3.org/TR/xquery >> http://www.w3.org/TR/xpath >> >> >> >> Can anyone else offer some links on XPATH, XQUERY, and SQL comparisons? >> >> >> Skip >> >> >> >> -----Original Message----- >> From: [email protected] [mailto:[EMAIL PROTECTED] >> Sent: Monday, April 30, 2007 12:59 AM >> To: [email protected] >> Subject: Re: [magnolia-user] Sql Queries on select control type >> >> >> >> 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 >>> ---------------------------------------------------------------- >>> >>> >>> >> >> > > > -- > David Smith > Network Operations Supervisor > Department of Entomology > Cornell University > 2132 Comstock Hall > Ithaca, NY 14853 > Phone: (607) 255-9571 > Fax: (607) 255-0940 > > > ---------------------------------------------------------------- > 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#a10265680 Sent from the Magnolia - User mailing list archive at Nabble.com. ---------------------------------------------------------------- for list details see http://www.magnolia.info/en/developer.html ----------------------------------------------------------------
