Hi Alina, On 11/22/2010 04:12 PM, afrey wrote:

Hi all,

I'm struggling creating a xwql query that joins two tables.

Let's say I have two classes: Fruit and Supplier.

Fruit has the following properties: Name, Supplier.

What's the type of the "Supplier" property? Is it a database list? Have you tried using a string property instead (e.g. supplier name) and a join condition like fruit.Supplier = supplier.Name ? Hope this helps, Marius

Supplier has the following properties: Name, City.

I need the query that returns: All Fruit that has Supplier with City='Melbourne'.

I can get all the Fruit objects: #set($fruits = $services.query.xwql("from doc.object(Fruit.FruitClass) as fru").execute())

And separately I can get all the Supplier objects that have city='Melbourne' #set($suppliers = $services.query.xwql("where doc.object(Supplier.SupplierClass).City='Melbourne'").execute())

But I can't combine them. Please advise.

Alina.

On 11/22/2010 04:27 PM, afrey wrote:

I tried the following query but I didn't get anything :( #set($fruits = $services.query.xwql("from doc.object(Fruit.FruitClass) as fru, doc.object(Supplier.SupplierClass) as sup where fru.Supplier.Name=sup.Name and sup.City='Melbourne'").execute())

On http://platform.xwiki.org/xwiki/bin/view/DevGuide/QueryGuide#HQueryLanguageE... there is a query described as "Search blogs per category". Blog category is a database tree but "member of" might work with database lists also. Can you try: #set($fruits = $services.query.xwql("from doc.object(Fruit.FruitClass) as fru, doc.object(Supplier.SupplierClass) as sup where sup member of fru.Supplier and sup.City='Melbourne'").execute()) Hope this helps, Marius

It doesn't have to be an xwql query. It could be sql, hql, anything that would work ;) -- View this message in context: http://xwiki.475771.n2.nabble.com/xwql-join-query-tp5762763p5763606.html Sent from the XWiki- Users mailing list archive at Nabble.com.