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