Hi, I'm still not getting it. Ok. Here is an example from the demo project. I hope you'll be able to reproduce what I'm trying to do.
>From JCR browser, "Dump" -> "data", "/contacts", "2 levels" returns: [quote]/contacts /contacts/jcr:uuid=3fc59e88-866f-4eeb-93a9-39ccbcf1f19a /contacts/jcr:createdBy=admin /contacts/jcr:mixinTypes=mix:lockable /contacts/jcr:created=2013-02-19T15:38:39.018-05:00 /contacts/jcr:primaryType=mgnl:content /contacts/MetaData /contacts/MetaData/jcr:uuid=b80cf9f1-b2ec-4a81-b828-ea9614c687c3 /contacts/MetaData/mgnl:creationdate=2013-02-19T15:38:39.018-05:00 /contacts/MetaData/jcr:createdBy=admin /contacts/MetaData/jcr:created=2013-02-19T15:38:39.018-05:00 /contacts/MetaData/jcr:primaryType=mgnl:metaData /contacts/JMustermann /contacts/JMustermann/photoCaption=Mr. Mustermann /contacts/JMustermann/name=JMustermann /contacts/JMustermann/officePhone=+41 61 228 90 00 /contacts/JMustermann/jcr:uuid=b296b951-6543-449c-9e3e-5e2e119bbc66 /contacts/JMustermann/jcr:mixinTypes=mix:lockable /contacts/JMustermann/givenName=Jens /contacts/JMustermann/[email protected] /contacts/JMustermann/photoAltText=Mr. Mustermann /contacts/JMustermann/jcr:created=2013-02-19T15:38:39.018-05:00 /contacts/JMustermann/streetAddress=St.Johanns-Vorstadt 38 /contacts/JMustermann/jcr:primaryType=Contact /contacts/JMustermann/officeFax=+41 61 228 90 01 /contacts/JMustermann/zip=4056 /contacts/JMustermann/web=http://www.magnolia-cms.com /contacts/JMustermann/organizationName=Magnolia International Ltd. /contacts/JMustermann/jcr:createdBy=admin /contacts/JMustermann/familyName=Mustermann /contacts/JMustermann/city=Basel /contacts/JMustermann/MetaData[mgnl:metaData] /contacts/JMustermann/photo[mgnl:resource][/quote] >From JCR browser, "Query" -> "data", "sql", "nt:base" select * from nt:base where jcr:path like '/contacts/%' and name='JMustermann' and city='Basel' returns: [quote]1 nodes returned in 0ms /contacts/JMustermann[/quote] Here is my Freemarker code: [code][#assign aList = cmsfn.search("data" "select * from nt:base where jcr:path like '/contacts/%' and name='JMustermann' and city='Basel'" "sql" "nt:base") /] [#list aList as anElement] The value of "name": ${anElement.name}<br/> The value of "city": ${anElement.city}<br/> [/#list] [/code] I get: [quote]The value of "name": JMustermann The value of "city": FreeMarker template error! Expression anElement.city is undefined on line 14, column 24 in ej/templates/Jeux/mainBodyTop.ftl. The problematic instruction: ---------- ==> ${anElement.city} [on line 14, column 22 in ej/templates/Jeux/mainBodyTop.ftl] in include "/ej/templates/Jeux/mainBodyTop.ftl" [on line 36, column 7 in ej/templates/HomePage/main.ftl] ----------[/quote] Here is other Freemarker code: [code][#assign aList = cmsfn.search("data" "select * from nt:base where jcr:path like '/contacts/%' and name='JMustermann' and city='Basel'" "sql" "nt:base") /] [#list cmsfn.children(aList) as anElement] The value of "name": ${anElement.name}<br/> The value of "city": ${anElement.city}<br/> [/#list][/code] I get: [quote]No signature of method children matches the arguments The problematic instruction: ---------- ==> list cmsfn.children(aList) as anElement [on line 12, column 1 in ej/templates/Jeux/mainBodyTop.ftl] in include "/ej/templates/Jeux/mainBodyTop.ftl" [on line 36, column 7 in ej/templates/HomePage/main.ftl] ----------[/quote] I would really appreciate having the solution as this is critical to migrate code from 4.4.9. Thanks -- Context is everything: http://forum.magnolia-cms.com/forum/thread.html?threadId=92cc9fac-0e0e-48f6-b13d-d3b888f441bc ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
