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 [email protected]
