topic Re: Document Library sort order in Alfresco Archive

Document Library sort order

nimbus58 — Wed, 18 Feb 2009 07:04:06 GMT

Hello,I am trying to find a way to sort the documents in the Share Document Library by creation date.Is it possible and if yes, … how!Thanks

Re: Document Library sort order

mikeh — Wed, 18 Feb 2009 08:59:15 GMT

Currently this isn't possible from the UI.

However, if you want to make the change permanently you can update / override the filters.lib.js script on the Repository.

classpath:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/filters.lib.js‍

At the top of the script is the default sort order:

var filterParams =
{
   …
   sortBy: "@{http://www.alfresco.org/model/content/1.0}name",
   sortByAscending: true,
   …
}‍‍‍‍‍‍‍

Thanks,
Mike

Re: Document Library sort order

abolotnov — Wed, 18 Feb 2009 18:18:28 GMT

Hi,

I was looking for a way to change my docLib sort order to have all files be sorted by their names. Your posting does help find a way to do this, but it looks like it's not working for me. I have looked at the filters.lib.js and its sort order on creation is set to "name", right. Yet the three test files I have now are sorted this way (by creation date):

Canon.txt
Aaron.txt
Bolton.txt

however, the filters.lib.js file has this:

…
sortBy: "@{http://www.alfresco.org/model/content/1.0}name",
sortByAscending: true,
…‍‍‍‍

please assist, am I doing something wrong?

Re: Document Library sort order

mikeh — Wed, 18 Feb 2009 20:51:01 GMT

It's to do with the underlying Lucene indexing (I believe - I'm no Lucene expert!). I can see it working here, so it will either be working on HEAD or will be merged to HEAD soon.

Thanks,
Mike

Re: Document Library sort order

nimbus58 — Fri, 20 Feb 2009 07:42:57 GMT

Thanks Mike,

Just what I needed!

Re: Document Library sort order

ssaravanan — Thu, 02 Apr 2009 16:33:46 GMT

In the filters.lib.js look for the following codeline

default:
         var filterQuery = "+PATH:\"" + parsedArgs.parentNode.qnamePath + "/*\"";
         filterQuery += " -ASPECT:\"{http://www.alfresco.org/model/content/1.0}workingcopy\"";
         filterParams.query = filterQuery;
         break;‍‍‍‍‍

Change that to look like this

default:
         var filterQuery = "+PATH:\"" + parsedArgs.parentNode.qnamePath + "/*\"";
         filterQuery += " -ASPECT:\"{http://www.alfresco.org/model/content/1.0}workingcopy\"";
         filterQuery.sortBy = "@{http://www.alfresco.org/model/content/1.0}name";
         filterQuery.sortByAscending = true;
         
         filterParams.query = filterQuery;
         break;‍‍‍‍‍‍‍‍

That will make sure that the documents are sorted in the document library
and in the All documents link in the document library

Re: Document Library sort order

mikeh — Thu, 02 Apr 2009 20:10:43 GMT

Hi Saravanan

No - that's not quite correct. The "sortBy" and "sortByAscending" values are members of the filterParams object literal, not the filterQuery string. The default sort order is by name (ascending) but this is overridden for the "recently modified" and "recently added" filters. As I mentioned before, you might need a fairly recent build to pick up on the changes to the query engine which correctly honoured the sortBy parameters.

Thanks,
Mike

Re: Document Library sort order

zaizi — Thu, 02 Apr 2009 22:29:27 GMT

Had to get this working for a client. So passed the filter param to the freemarker template and did the sorting in freemarker.

Re: Document Library sort order

mycroes — Tue, 02 Mar 2010 15:33:05 GMT

I was wondering if someone got this working without changing the filters.lib.js in the deployed war. I'm trying to do the same thing (well, for action-sets.lib.js actually), but I can't seem to get it to override the default…
Regards,

Michael

Re: Document Library sort order

tmeedend — Fri, 31 Aug 2012 08:21:24 GMT

I was wondering if someone got this working without changing the filters.lib.js in the deployed war. I'm trying to do the same thing (well, for action-sets.lib.js actually), but I can't seem to get it to override the default…
Regards,

Michael

I also tried to override this file with a jar. I tried to put it in :
- config\alfresco\templates\webscripts\org\alfresco\slingshot\documentlibrary-v2\filters.lib.js
- config\alfresco\extension\templates\webscripts\org\alfresco\slingshot\documentlibrary-v2\filters.lib.js

Nothing overrided the original file.

The only way I found that worked is to delete the original filters.lib.js. Without the original file, Alfresco uses my custom filters.lib.js (if it's in config\alfresco\templates\webscripts\org\alfresco\slingshot\documentlibrary-v2\filters.lib.js of my jar)

With Alfresco 4.0.2.9