...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]> ----------------------------------------------------------------
