Ok, what I'm trying is:
[@cms.query repository="data"
query="select * from nt:base where jcr:path like
'/company/Big-Flower-Inc/Permanent-Employees/%' and contains(*,
'developer')" type="sql" var="developers" /]
[#list developers as cDev]
${cDev}
[/#list]
All I get back is a single record displaying 'company'.The same command used
in the JCR Query tool list multiple records as expected. What have I done
wrong?
Will Scheidegger wrote:
>
> You can easily use the cms:query Magnolia tag for this, e.g. in Freemarker
>
> [#assign cms=JspTaglibs["cms-taglib"]]
> [#assign queryString]...my sql or xpath query...[/#assign]
> [@cms.query repository=data" query=queryString type="xpath"
> var="employees" /]
> [#list employees as currEmployee]
> ...
> [/#list]
>
> See
> -
> http://documentation.magnolia-cms.com/reference/templating/freemarker.html
> -> "Using Magnolia Tags"
> -
> http://nexus.magnolia-cms.com/content/sites/magnolia.public.sites/ref/4.3.8/magnolia-taglib-cms/tagreference.html#cms:query
>
> Cheers,
> -will
>
> On 09.03.2011, at 11:09, Jon RINGWOOD PSE 55500 wrote:
>
>>
>> Is it possible to list multiple data items in a paragraph? For instance,
>> using the STK example data, could a list of Permanent Employees be
>> created? I know the contact paragraph can be used to select an individual
>> data node and then display it but it would be really useful to be able to
>> list all data items for a specific node.
>>
>> Thanks
>>
>> Jon
>>
>>
>> ----------------------------------------------------------------
>> For list details see
>> http://www.magnolia-cms.com/home/community/mailing-lists.html
>> To unsubscribe, E-mail to: <[email protected]>
>> ----------------------------------------------------------------
>> This email and any other accompanying document (s) contain information
>> from Kent Police, which is confidential or privileged. The information
>> is intended to be for the exclusive use of the individual(s) or bodies to
>> whom it is addressed. The content including any subsequent replies could
>> be disclosable if relating to a criminal investigation or civil
>> proceedings. If you are not the intended recipient, be aware that any
>> disclosure, copying, distribution or use of the contents of this
>> information is prohibited. If you have received this email in error,
>> please notify us immediately by contacting the sender or telephoning
>> 01622 690690.
>
>
>
> ----------------------------------------------------------------
> For list details see
> http://www.magnolia-cms.com/home/community/mailing-lists.html
> To unsubscribe, E-mail to: <[email protected]>
> ----------------------------------------------------------------
>
>
>
--
View this message in context:
http://old.nabble.com/Displaying-Multiple-data-items-tp31104957p31627706.html
Sent from the Magnolia - User mailing list archive at Nabble.com.
----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <[email protected]>
----------------------------------------------------------------
