CODEWITHSUNDEEP
restcollectionslotus-dominoget-request
einue
einue

Reputation: 27

DOMINO REST API get Collection sort column

Hi I'm trying to get a sorted Collection from the Domino Rest Api. My database name is "Test/JSON_Views.nsf" and my views name "List".

The endpoint I use is **/Test/JSON_Views.nsf/api/data/collections/name/List?sortcolumn=title&sortorder=ascending&count=20

But the JSON-Response entries aren't sorting by title in ascending order.

Should I make any settings to the column properties in the designer? If I set descending there for the title-column it works. But I want to change the sorting in my external java-application.

Is my endpoint correct? I use this Domino API Docu as Reference.

Upvotes: 1

Views: 332

Answers (2)

Knut Herrmann
Knut Herrmann

Reputation: 30960

Add an additional sorting to your title column:

enter image description here

This gives the API the possibility to sort by title in both directions. You can do this with other columns too so you are very flexible in sorting this way.

Upvotes: 2

Duston
Duston

Reputation: 1641

The doc says that if the column isn't sorted in design then the sortcolumn parameter has no effect, so the answer is "Yes" you should change the design of the desired column. If doing that is unworkable in whatever context you use it, then create a second view and use that instead.

Upvotes: 1

Related Questions