jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Herman <MHer...@NBME.org>
Subject Re: SQL2 and references
Date Tue, 27 Sep 2011 23:15:56 GMT

Lukas Kahwe Smith wrote:
> <D:searchrequest xmlns:D="DAV:"><JCR-SQL2></JCR-SQL2></D:searchrequest>

I'm a bit confused about the use of "reference" but i was able to get
results using the property name. I dont' know if "reference" a special word
or just an example of a property name.  Here is my query that does return a

SELECT * FROM [nt:unstructured] AS data INNER JOIN [nt:unstructured] AS
referring ON referring.[dong] = data.[jcr:uuid] WHERE data.lala= 'huii'

I tried to get the data set up how you explained it, just in case, here is

/foo [nt:unstructured]
/foo/bar [nt:unstructured]
/foo/bar@lala = huii (lala is string property of bar)
/ding [nt:unstructured]
/ding@dong = ##barUUID### (dong is a property of type "Reference")

View this message in context: http://jackrabbit.510166.n4.nabble.com/SQL2-and-references-tp3848951p3849480.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

View raw message