In the Data-Repository i have defined a Contact-Type "Partner"
with a CheckBox in the Dialog, to define (multiple) Partnership
Contact in JCR-Browser:
+- Company:String
+- Adress:String
+- ZIP-City:String
+- Phone:String
+- Partnership:Checkbox
+-0:Sales-Partner
+-0:Support-Partner
+-0:Knowledge-Partner
[code]
works in tools/jcr-queries as expected:
[quote]select * from nt:base where jcr:path like '%/Partner/%' and itemtype =
'Partner'[/quote]
also in ftl Template with:
[@cms.query
repository="data"
query="select * from nt:base
where jcr:path like ${pathToData}
and itemtype = 'Partner'"
type="sql"
var="FoundContentNodes"
nodeType="nt:base"
/]
[/code]
How can i build a SQL-query that the result-contentNode contains each contact
of each checked Partnership-Category, ordered by the Partnership-Categories,
so that i can iterate over "myContactNodes" in my Freemarker Template
to display a List of Contacts like:
Sales-Partner
**************
[Company1, Street 1, 1111 City1, ...]
[Company2, Road 2, 2222 City2, ...]
[Company3, Street 3, 3333 City3, ...]
[Company4, place 4, 4444 City4, ...]
...
Support-Partner
**************
[Company2, Road 2, 2222 City2, ...]
Knowledge-Partner
**************
[Company2, Road 2, 2222 City2, ...]
[Company4, place 4, 4444 City4, ...]
In other words, "how is it possible to check if the checkboxes are checked in
the SQL-Query"?
Any hint or help is very appreciated!
Thanks in advance
--
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]>
----------------------------------------------------------------
