Hi, yes, that's possible. the SQL2 query is:
select * from [wr:profile] as profile inner join [wr:user] as user on profile.[jcr:uuid] = user.[wr:profile] you can also build the query using the QueryObjectModelFactory. For an introduction see section 6 of the JSR 283 draft specification available here: http://jcp.org/aboutJava/communityprocess/pfd/jsr283/index.html please note that those interfaces are only implemented in Jackrabbit 2.0 (currently available as alpha releases). regards marcel On Thu, Aug 27, 2009 at 09:25, Luca Tagliani<[email protected]> wrote: > > Hi all, > I wonder if it is possible to execute this query: > > "select profile.*, user.* from wr:profile as profile inner join wr:user as > user on user.id = profile.wrprop:user" > > where wr:profile and wr:user ar nodeTypeName and wrprop:user is a property > of type Reference which references an instance of wr:profile. > > Also, is it possible to build the query using the JSR283 API? > > Thanks in advance for your help > > BR > > Luca Tagliani > -- > View this message in context: > http://www.nabble.com/Query-using-joins-tp25167225p25167225.html > Sent from the Jackrabbit - Users mailing list archive at Nabble.com. > >
