Alexander Klimetschek wrote: > > On Thu, Feb 5, 2009 at 4:28 PM, gregoryjoseph > wrote: >>> SELECT * FROM my:nodetype WHERE tag='foo' >>> Not quite - i do not know all possible values for the tag property and i >>> went to know how many time each distinct value is used. > > For multi-value properties, the meaning of "=" is slightly different > in jcr xpath/sql: it means that the exact value occurs at least once > in the array of values. > > See section 6.6.4.10 (xpath) and 8.5.2.7 (sql) of the jcr spec: > > http://www.day.com/specs/jcr/1.0/6.6.4.10_Searching_Multi-value_Properties.html > > http://www.day.com/specs/jcr/1.0/8.5.2.7_Multi-value_Properties.html > Thanks for the hint; however, I still don't know what any of the values are. My initial fake query might have been misleading because of the prop_name='foo' clause, might have been clearer with prop_name='tag'. In short, I know the property *name* I'm looking for, and I want to collect all its existing *values* over a set of nodes in my tree. -- View this message in context: http://www.nabble.com/Counting-occurences-of-a-given-property%27s-different-values-tp21852761p21854986.html Sent from the Jackrabbit - Users mailing list archive at Nabble.com.