topic Re: Alfresco Pagination Basic concept in Alfresco Forum

Alfresco Pagination Basic concept

sachindac75 — Thu, 27 Jul 2017 11:36:04 GMT

Hi All,I am using alfresco-5.0.d and solr4.I have implemented pagination in my application with this code.PagingRequest paging=new PagingRequest(skipResult,maxResult); List<Pair<QName, Boolean>> sortProps = new ArrayList<Pair<QName, Boolean>>(); sortProps.add(new Pair<

Re: Alfresco Pagination Basic concept

afaust — Thu, 27 Jul 2017 16:23:14 GMT

SOLR4 is not relevant for your use case as the FileFolderService uses database queries for data retrieval. The list operation retrieves the children of the folder in the order they are provided by the database (not necessarily the same as the creation date) and only performs an in-memory sort. If you do not specify a specific sort order, it will use the order in which the items have been added to the folder (which also is not necessarily the same as the creation date, e.g. when an item was moved into a folder long after it was created).

As an alternative to FileFolderService.list() you can also do an FTS query against the database using the Transactional Metadata Query feature added with Alfresco 4.2. A FTS query will apply the sort condition immediately within the SQL select statement. The same also applies if you use SOLR4 for this type of query (e.g. if you request the query to use EVENTUAL consistency or your database has not been prepared for Transactional Metadata Queries).

Re: Alfresco Pagination Basic concept

sachindac75 — Thu, 27 Jul 2017 16:34:13 GMT

Thanks to quick reply @Axel Faust

I am completely agree with your answer.But i need to use pagination also .So for that i want alfresco to first get all result, sort the result based on sortProps and then revert the result.but it seems first alfresco getting the result based on my paging request and then performing sort then reverting.

Re: Alfresco Pagination Basic concept

afaust — Thu, 27 Jul 2017 17:19:50 GMT

Search also has pagination support...

Re: Alfresco Pagination Basic concept

sachindac75 — Fri, 28 Jul 2017 04:52:32 GMT

but that will reduce the performance it seems.Suppose there is 1k records in a folder so getting page by page is faster then getting all data using fts query and then sort