nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Sorting output of ListObjects by name

Dan_Duffy

We are building a servlet-based Livelink app, and to list the contents of a folder we have a method that calls LAPI_DOCUMENTS.ListObjects(int volumeID, int objectID, String viewName, String queryStr, int permissions, LLValue children). The results are put into a java.util.Vector. There is one problem: the results are not listed in alphabetical order. Is there any way to sort them? Could I make a view? I created a view (long after Livelink was installed) that contained the following text:"select * from dtree order by name", but this has no effect on the sorting.I saw a post on Knowledge Center (https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2585466&objAction=view&show=2) saying that the view should be in the Livelink database schema. Is creating a view after installation sufficient? Is it possible to create a view that takes a parameter that I can send to it in the ListObjects call? Is there anything I can put in the query string? If I make the query string "order by name", then I get no results back.

Find more posts tagged with

Comments

Geoff_Price

I, too, would be interested in a way to get a sorted list of objects back from ListObjects. Has anyone been able to do this? I'm thinking of just storing them in a Collection and calling a sort() on it. It would be nice if ListObjects would have a sort parameter!

Kyle_Swidrovich

Hello,

The ListObjects call has hardcoded sort logic that forces the resultant RecArray to produce a set already sorted by the Name column of the results.

Due to this hardcoded sort, there is no way to drive an alternate sort order via any ListObjects parameter.

You would need to customize the Oscript LAPI handler for ListObjects to change this logic.

I should note that the sort that occurs is performed in Oscript, AFTER the query has been executed (which sorts by DataID).

Regards,
Kyle

Kyle_Swidrovich

Quoted Dan Duffy (dan.duffy@bankofamerica.com) on 2011/08/29 00:47:

We are building a servlet-based Livelink app, and to list the contents of a folder we have a method that calls LAPI_DOCUMENTS.ListObjects(int volumeID, int objectID, String viewName, String queryStr, int permissions, LLValue children). The results are put into a java.util.Vector. There is one problem: the results are not listed in alphabetical order. Is there any way to sort them? Could I make a view? I created a view (long after Livelink was installed) that contained the following text: "select * from dtree order by name", but this has no effect on the sorting. I saw a post on Knowledge Center (https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2585466&objAction=view&show=2) saying that the view should be in the Livelink database schema. Is creating a view after installation sufficient? Is it possible to create a view that takes a parameter that I can send to it in the ListObjects call? Is there anything I can put in the query string? If I make the query string "order by name", then I get no results back.

Hi Dan,

Please see my previous post regarding sorting.
Specific to your case, I would recommend sorting the vector within Java once it has been populated.

Regards,
Kyle