the return node type is not specified.
try adding nodeType="nt:base"
On May 16, 2011, at 12:01 PM, Jon Ringwood wrote:
>
>
> 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]>
> ----------------------------------------------------------------
-
Best regards,
Jan Haderka, PhD.
Magnolia International Ltd.
http://www.magnolia-cms.com
Register now for Magnolia Conference 2011:
http://www.magnolia-cms.com/conference
--------------------------------------
Magnolia® - Simple Open-Source Content Management
----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <[email protected]>
----------------------------------------------------------------
