<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Retrieving the content of a given folder in a .ftl script in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/retrieving-the-content-of-a-given-folder-in-a-ftl-script/m-p/148960#M103985</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I found this useful guide: &lt;/SPAN&gt;&lt;A href="http://wiki.alfresco.com/wiki/FreeMarker_Template_Cookbook" rel="nofollow noopener noreferrer"&gt;http://wiki.alfresco.com/wiki/FreeMarker_Template_Cookbook&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The guide contains an example that seems to fit well with my needs:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt; &lt;/SPAN&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&amp;lt;table&amp;gt;&lt;BR /&gt; &amp;lt;#list companyhome.childByNamePath["/Company Home/Marketing Stuff/Whitepapers"].children as child&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;lt;#if child.isDocument&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;tr&amp;gt;&amp;lt;td&amp;gt;&amp;lt;a href="/alfresco${child.url}" target="new"&amp;gt;${child.properties.name}&amp;lt;/a&amp;gt;&amp;lt;/td&amp;gt;&amp;lt;/tr&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;lt;/#if&amp;gt;&lt;BR /&gt; &amp;lt;/#list&amp;gt;&lt;BR /&gt; &amp;lt;/table&amp;gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;I've pasted the code in my test .ftl script, but it does not work. This is the error returned:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;An error occurred in one of the dashlets. &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Error during processing of the template 'Expression companyhome.childByNamePath["/Company Home/Marketing Stuff/Whitepapers"] is undefined on line 6, column 9 in alfresco/templates/foldercontent1.ftl.'. Please contact your system administrator.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 21 Mar 2008 23:00:07 GMT</pubDate>
    <dc:creator>theorbix</dc:creator>
    <dc:date>2008-03-21T23:00:07Z</dc:date>
    <item>
      <title>Retrieving the content of a given folder in a .ftl script</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/retrieving-the-content-of-a-given-folder-in-a-ftl-script/m-p/148959#M103984</link>
      <description>Hello, I'm stuck in trying to do something that should be fairly simple…I'm writing a dashlet that should list all the documents in a given space.I've started writing the .ftl script that should retrieve the list of documents contained in the space, but I don't know how to build the query.The path o</description>
      <pubDate>Fri, 21 Mar 2008 22:20:35 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/retrieving-the-content-of-a-given-folder-in-a-ftl-script/m-p/148959#M103984</guid>
      <dc:creator>theorbix</dc:creator>
      <dc:date>2008-03-21T22:20:35Z</dc:date>
    </item>
    <item>
      <title>Re: Retrieving the content of a given folder in a .ftl script</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/retrieving-the-content-of-a-given-folder-in-a-ftl-script/m-p/148960#M103985</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I found this useful guide: &lt;/SPAN&gt;&lt;A href="http://wiki.alfresco.com/wiki/FreeMarker_Template_Cookbook" rel="nofollow noopener noreferrer"&gt;http://wiki.alfresco.com/wiki/FreeMarker_Template_Cookbook&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The guide contains an example that seems to fit well with my needs:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt; &lt;/SPAN&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&amp;lt;table&amp;gt;&lt;BR /&gt; &amp;lt;#list companyhome.childByNamePath["/Company Home/Marketing Stuff/Whitepapers"].children as child&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;lt;#if child.isDocument&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;tr&amp;gt;&amp;lt;td&amp;gt;&amp;lt;a href="/alfresco${child.url}" target="new"&amp;gt;${child.properties.name}&amp;lt;/a&amp;gt;&amp;lt;/td&amp;gt;&amp;lt;/tr&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;lt;/#if&amp;gt;&lt;BR /&gt; &amp;lt;/#list&amp;gt;&lt;BR /&gt; &amp;lt;/table&amp;gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;I've pasted the code in my test .ftl script, but it does not work. This is the error returned:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;An error occurred in one of the dashlets. &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Error during processing of the template 'Expression companyhome.childByNamePath["/Company Home/Marketing Stuff/Whitepapers"] is undefined on line 6, column 9 in alfresco/templates/foldercontent1.ftl.'. Please contact your system administrator.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 21 Mar 2008 23:00:07 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/retrieving-the-content-of-a-given-folder-in-a-ftl-script/m-p/148960#M103985</guid>
      <dc:creator>theorbix</dc:creator>
      <dc:date>2008-03-21T23:00:07Z</dc:date>
    </item>
    <item>
      <title>Re: Retrieving the content of a given folder in a .ftl script</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/retrieving-the-content-of-a-given-folder-in-a-ftl-script/m-p/148961#M103986</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Ok, in case someone is wondering what was the problem… it was a mistake in the logic of my script.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;It turns out that this exception:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="color:#0000BF;"&gt;Error during processing of the template 'Expression companyhome.childByNamePath["Company Home/Marketing Stuff/Whitepapers"] is undefined on line 6, column 9 in alfresco/templates/foldercontent1.ftl.'. Please contact your system administrator. &lt;BR /&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;happens because the path name specified is invalid, or inaccessble to the user because of its ACL settings, or (and this is my case) because I added the /CompanyHome/ prefix, that is not required.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;If the path specified is correct, then the childByNamePath[] method works well.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;So the bottom line is that I modified my fremarker script in order to test if the folder exists before tring to list its content. Here is the correct code:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&amp;lt;#ftl strip_whitespace=true /&amp;gt;&lt;BR /&gt;&amp;lt;#setting locale="it_IT"/&amp;gt;&lt;BR /&gt;&amp;lt;#setting datetime_format="short" /&amp;gt;&lt;BR /&gt;&lt;BR /&gt;&amp;lt;!– path name of the space to be listed (case sensitive, must not include the /Company Home/ prefix) –&amp;gt;&lt;BR /&gt;&amp;lt;#assign folderName="Marketing Stuff/Whitepapers" /&amp;gt;&lt;BR /&gt;&lt;BR /&gt;&amp;lt;#if companyhome.childByNamePath[folderName]?exists&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;lt;#assign folderObj=companyhome.childByNamePath[folderName]&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;lt;table&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;tbody&amp;gt; &lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;!– Display all documents in the space –&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;#list folderObj.children as child &amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;tr&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;td&amp;gt;${child.properties.name}&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/td&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/tr&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/#list&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/tbody&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;lt;/table&amp;gt;&lt;BR /&gt;&amp;lt;#else&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;lt;b&amp;gt;The space &amp;lt;i&amp;gt;${folderName}&amp;lt;/i&amp;gt; does not exist…&amp;lt;/b&amp;gt;&lt;BR /&gt;&amp;lt;/#if&amp;gt;&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 17 Apr 2008 22:08:33 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/retrieving-the-content-of-a-given-folder-in-a-ftl-script/m-p/148961#M103986</guid>
      <dc:creator>theorbix</dc:creator>
      <dc:date>2008-04-17T22:08:33Z</dc:date>
    </item>
  </channel>
</rss>

