Sorting a documentList

, ,
1

Can someone please help me to sort a documentList based on a particular value from a field within that documentList??

2

Hi Ganesh,

Use the service sortDocuments service present in WmPublic to sort the document list based on the key value. Also this service allows you to sort in ascending / descending order based on the key value.

Note: While specifying the key field name, it is sufficient to mention the field name and not the entire path.

Regards,
Shriraksha A N

3

Thanks Sriraksha,

But im using wM 6.5.

4

You got to implement a java service using the API functions I suppose. There is a function sortIDataArrayByKey in IDataUtil class. Just refer the Developer JAVA API docs for more information. Check if the below works in WM6.5

/ pipeline
IDataCursor pipelineCursor = pipeline.getCursor(); 
// documentList
IData[]    documentList = IDataUtil.getIDataArray( pipelineCursor, "documentList" );
String    keyname = IDataUtil.getString( pipelineCursor, "keyname" );
String    compareType = IDataUtil.getString( pipelineCursor, "compareType" );


try{
  if (documentList.length > 0){
    if(compareType.equals("EQUALS"))
        IDataUtil.put(pipelineCursor,"sortedDocumentList", IDataUtil.sortIDataArrayByKey(documentList,keyname,IDataUtil.COMPARE_TYPE_EQUALS,null,false));

    else if(compareType.equals("NUMERIC"))
        IDataUtil.put(pipelineCursor,"sortedDocumentList", IDataUtil.sortIDataArrayByKey(documentList,keyname,IDataUtil.COMPARE_TYPE_NUMERIC,null,false));

    else if(compareType.equals("TIME"))
        IDataUtil.put(pipelineCursor,"sortedDocumentList", IDataUtil.sortIDataArrayByKey(documentList,keyname,IDataUtil.COMPARE_TYPE_TIME,null,false));

    documentList = null;
  }
    
}catch(Exception e){

    throw new ServiceException(e);
}
finally{

   if(pipelineCursor != null)
    pipelineCursor.destroy();

}


Cheers
Guna