Hi Damian, Given the structure of your graph as I've interpreted it, something like this might work, though I'm not sure it's particularly efficient:
select $itempid $itemname $producername from <#ri> where $item <fedora-rels-ext:isMemberOf> <info:fedora/ns:items> and $item <dc:identifier> $itempid and $item <dc:title> $itemname and $item <ns:producer> $producerid and $producer <dc:identifier> $producerid and $producer <dc:title> $producername - Chris On Tue, Dec 7, 2010 at 8:02 AM, Damian Kaliszan <dam...@man.poznan.pl> wrote: > Dear All, > > I have the following problem. I have 2 collections. > They look (to make it simpler) like this: > - The first one is called 'items'. Each item (id, name, producer id) > is <fedora-rels-ext:isMemberOf> of that collection > - The second one is 'producers' collection . Each producer (id, name) > is <fedora-rels-ext:isMemberOf> of that collection > > I'd like to create a query returning the following > item id, item name, producer name. > > How to link producer id from the main query with producer id in the > subquery? > The query would be something like this..... > > > select $pid $name $producerId > subquery(select $producerName > from <#ri> > where $member1 <dc:identifier> $prodId > and $prodId <mulgara:is> $producerId > and #member1 <dc:title> $producerName > and $member1 <fedora-rels-ext:isMemberOf> > <info:fedora/ns:producers>) > > from <#ri> > where $member <dc:identifier> $pid > and $member <dc:title> $name > and $member <ns:producer> $producerId > and $member <fedora-rels-ext:isMemberOf> <info:fedora/ns:items> > > > How to make it working? Please help.. > > Best regards, > Damian > > > ------------------------------------------------------------------------------ > What happens now with your Lotus Notes apps - do you make another costly > upgrade, or settle for being marooned without product support? Time to move > off Lotus Notes and onto the cloud with Force.com, apps are easier to build, > use, and manage than apps on traditional platforms. Sign up for the Lotus > Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d > _______________________________________________ > Fedora-commons-users mailing list > Fedora-commons-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/fedora-commons-users > ------------------------------------------------------------------------------ What happens now with your Lotus Notes apps - do you make another costly upgrade, or settle for being marooned without product support? Time to move off Lotus Notes and onto the cloud with Force.com, apps are easier to build, use, and manage than apps on traditional platforms. Sign up for the Lotus Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d _______________________________________________ Fedora-commons-users mailing list Fedora-commons-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
