jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lukas Kahwe Smith <...@pooteeweet.org>
Subject Re: SQL2 and references
Date Wed, 28 Sep 2011 07:55:36 GMT

On Sep 28, 2011, at 01:15 , Mark Herman wrote:

> 
> 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
> result:

yeah it was just an example property name that Jukka used in his reply.

> 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
> mine:
> 
> /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")


ok thx .. i will need to simplify my setup as much as i can, because i see no reason why i
should have issues with running JOINs specifically.

regards,
Lukas Kahwe Smith
mls@pooteeweet.org




Mime
View raw message