<?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 Blog and Article post order. in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/blog-and-article-post-order/m-p/247684#M200814</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I'm running the lastest nightly build of 3.4d and I'm testing out a default Web Quick Start Site and made a few test articles and blog posts. I've noticed on both of them all new posts are showing up in chronological order (oldest first). How do I make them display in reverse chronological order (newest article first)?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;In the document library for the news sections, the query field on the metadata for the section.articles folder has the following query:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;select d.* from cmis:document as d where in_tree(d, '${section:.}') and d.cmis:objectTypeId='D:ws:article' order by d.cmis:creationDate desc&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;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;also respectively in the query field on the metadata for the latest.articles folder in the blog section has the following:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;select d.* from cmis:document as d where in_folder(d, '${section:.}') and d.cmis:objectTypeId='D:ws:article' and d.cmis:name not like 'comment-thankyou.html' order by d.cmis:creationDate desc&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;I'm assuming the part where it says "order by d.cmis:creationDate desc" is the command to display the articles in decending order. I've tried editing this query with no luck. I've tried changing the "desc" to "asc" or leaving it blank, nothing seems to work. Is there some other criteria that articles and blog posts are sorted by that I might be missing?&amp;nbsp; :cry:&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 14 Jan 2011 22:37:50 GMT</pubDate>
    <dc:creator>foosetv</dc:creator>
    <dc:date>2011-01-14T22:37:50Z</dc:date>
    <item>
      <title>Blog and Article post order.</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/blog-and-article-post-order/m-p/247684#M200814</link>
      <description>I'm running the lastest nightly build of 3.4d and I'm testing out a default Web Quick Start Site and made a few test articles and blog posts. I've noticed on both of them all new posts are showing up in chronological order (oldest first). How do I make them display in reverse chronological order (ne</description>
      <pubDate>Fri, 14 Jan 2011 22:37:50 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/blog-and-article-post-order/m-p/247684#M200814</guid>
      <dc:creator>foosetv</dc:creator>
      <dc:date>2011-01-14T22:37:50Z</dc:date>
    </item>
    <item>
      <title>Re: Blog and Article post order.</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/blog-and-article-post-order/m-p/247685#M200815</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Following up, with some further investigating I'm finding that even if you remove the query completely from any of the articles folders or use any of the folders that are intended to be manually updated, the Web Assets you select will not stay in the order you select. They seem to automatically sort into oldest to the top and newest to the bottom. So as of this moment I can't seem to find a way to have articles or blog post sort in the order of the newest asset on top (as most blogs are formatted) either manually or automatically. I'm currently looking through the Quick Start files to find where to maybe write some code to make this happen. Does anyone have some thoughts?&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 18 Jan 2011 07:54:46 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/blog-and-article-post-order/m-p/247685#M200815</guid>
      <dc:creator>foosetv</dc:creator>
      <dc:date>2011-01-18T07:54:46Z</dc:date>
    </item>
    <item>
      <title>Re: Blog and Article post order.</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/blog-and-article-post-order/m-p/247686#M200816</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Unfortunately this is a weakness of asset collections that we didn't have time to address in this cycle, but we do have on the list for the next one. The problem arises because asset collections reference assets using peer associations that cannot be ordered currently, and there was no suitable alternative that provided both ordering and a user interface in Share to manage the order. We considered a few options to try to resolve this, but none would fit in the available time. I know this is a real problem, and will work on it to get a solution out as soon as possible. It is relatively easy to solve for dynamic asset collections, but harder for static asset collections. Perhaps an initial step that handled the former would still be useful?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;In the meantime, the class that returns the asset ids for a given asset collection is AssetCollectionGet (a java-backed webscript). It would be this class that would need to be adjusted to change the way the results are ordered. The only other option would be to order the assets in memory on the web tier. Sorry this isn't ideal. We'll address it as soon as we can.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 18 Jan 2011 08:43:02 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/blog-and-article-post-order/m-p/247686#M200816</guid>
      <dc:creator>bremmington</dc:creator>
      <dc:date>2011-01-18T08:43:02Z</dc:date>
    </item>
    <item>
      <title>Re: Blog and Article post order.</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/blog-and-article-post-order/m-p/247687#M200817</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Thank you for your post, it was EXTREMELY helpful. I was able to reverse the order using your suggestion of looking at the AssetCollectionGet class and making a small change. I went into the assetcollection.get.json.ftl file and changed the following lines:&lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&amp;lt;#list collection.assetIds as assetId&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; "${assetId}"&amp;lt;#if assetId_has_next&amp;gt;,&amp;lt;/#if&amp;gt;&lt;BR /&gt;&amp;lt;/#list&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;/CODE&gt;&lt;/PRE&gt;&lt;SPAN&gt;to add a reverse command to the freemarker tag like so:&lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&amp;lt;#list collection.assetIds?reverse as assetId&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; "${assetId}"&amp;lt;#if assetId_has_next&amp;gt;,&amp;lt;/#if&amp;gt;&lt;BR /&gt;&amp;lt;/#list&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;/CODE&gt;&lt;/PRE&gt;&lt;SPAN&gt;After a restart of Alfresco, all the quick start pages that display assets are now listing them in reverse chronological order (newest to oldest), much more like how blogs are supposed to be!&amp;nbsp; &lt;img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" /&gt; &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I'll keep this setting until you guys can address the asset order via the query. So far it seems like it should work fine.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 18 Jan 2011 10:26:56 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/blog-and-article-post-order/m-p/247687#M200817</guid>
      <dc:creator>foosetv</dc:creator>
      <dc:date>2011-01-18T10:26:56Z</dc:date>
    </item>
  </channel>
</rss>

