...still working on it! It is some kind of newland for me.

I need a contentNode containing each company once for each partnership it 
contains, to get a list separated by partnership.

The same company which is sales-partner and support-partner(Compay1) should be 
twice in the result.

In my oppinion that should be possible by query:

[code]select distinct from nt:base
where jcr:path like '%/Partner/%'
and itemtype = 'Partner'
and (partnership='Sales-Partner' or partnership='Support-Partner')[/code]

but the last line wont work, because i dont know how to access the mgnl:content 
from "partnership"

i really apreciate any help or hinting in the right direction!

[b]JCR-Dump of Data-Repo (Partner):[/b]
[code]
/Partner/Compay1
/Partner/Compay1/name=Compay1
/Partner/Compay1/itemtype=Partner
/Partner/Compay1/jcr:created=2013-12-06T10:39:30.688+01:00
/Partner/Compay1/streetAddress=Strreet 1
/Partner/Compay1/jcr:primaryType=Partner
/Partner/Compay1/city=Village1
/Partner/Compay1/zip=ZIP1
/Partner/Compay1/web=www.eins.ch

/Partner/Compay1/partnership
/Partner/Compay1/partnership/1=Sales-Partner
/Partner/Compay1/partnership/0=Support-Partner


/Partner/Compay2 
/Partner/Compay2/itemtype=Partner  

/Partner/Compay2/name=Compay2
/Partner/Compay2/streetAddress=Road 2
/Partner/Compay2/jcr:primaryType=Partner
/Partner/Compay2/city=City2
/Partner/Compay2/zip=ZIP2
/Partner/Compay2/web=www.zwei.ch

/Partner/Compay2/partnership
/Partner/Compay2/partnership/0=Support-Partner


some Details about "partnership"
--------------------------------
/Partner/Compay2/partnership/jcr:uuid=b195e0a3-2415-4645-8c1e-75a97a93037a
/Partner/Compay2/partnership/jcr:mixinTypes=mix:lockable
/Partner/Compay2/partnership/jcr:created=2013-12-06T10:40:06.060+01:00
/Partner/Compay2/partnership/jcr:primaryType=mgnl:contentNode
/Partner/Compay2/partnership/MetaData
/Partner/Compay2/partnership/MetaData/jcr:uuid=5ae04ef4-bca5-4ecc-a1c1-8efdb5c0e0b2
/Partner/Compay2/partnership/MetaData/mgnl:creationdate=2013-12-06T10:40:06.060+01:00
/Partner/Compay2/partnership/MetaData/jcr:created=2013-12-06T10:40:06.060+01:00
/Partner/Compay2/partnership/MetaData/jcr:primaryType=mgnl:metaData[/code]

-- 
Context is everything: 
http://forum.magnolia-cms.com/forum/thread.html?threadId=b016983b-e042-4b54-955e-3432b917673d


----------------------------------------------------------------
For list details, see http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: <[email protected]>
----------------------------------------------------------------

Reply via email to