http://nexus.magnolia-cms.com/content/sites/magnolia.public.sites/ref/4.4/magnolia-taglib-cms/tagreference.html#cms:query
;) the tag defaults to mgnl:content (web pages) while the Tools/JCR Queries defaults its Result ItemType to nt:base Cheers, Jan On May 16, 2011, at 2:54 PM, Jon RINGWOOD PSE 55500 wrote: > 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 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]> > ---------------------------------------------------------------- > > > ---------------------------------------------------------------- > 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]> ----------------------------------------------------------------
