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
> ----------------------------------------------------------------
>
>
--
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
----------------------------------------------------------------
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/developer.html
----------------------------------------------------------------
