That's great, thanks Jan. Not seen mention of that anywhere.

>>> On 16/05/11 at 12:46, Jan Haderka <[email protected]>
wrote:

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 Ope
n-Source Content Management



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


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

Reply via email to