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
