Ordering the user search result with cql has no effect

Forge
, , ,
1

Hi there,

I am using the CQL Rest-API to request all users and I would like to get them in alphabetical order. Unfortunately the order by keyword does not work combined with user.fullname.

My request:

/wiki/rest/api/search?cql=type=user%20order%20by%20user.fullName

With or without order by fullname does not change the result. Do you know if it is possible to order it by fullname somehow?

Thanks in advance.
Sven

2

Hi @SvenHe ,

Order by does not support all fields and, unfortunately, as you have encountered, user.fullname is not supported.

So far, I do not know of any workarounds but if this is imperative to have for your use case you might want to suggest this feature/enhancement in here for the team/s to prioritize accordingly.

Cheers,
Ian