Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
wellington1
Partner - Contributor
Partner - Contributor

Theres a way to sort a table by name of custom property with QRS API ?

I want to sort a table by a custom property name, theres a way to do this ?

I'm using this :

qrs/App/table?&xrfkey=aaaaaaaaaaaaaaaa&orderAscending=true&filter=published eq true&skip=0&sortColumn=namet&take=20

 
What i actually want to do basically:
qrs/App/table?&xrfkey=aaaaaaaaaaaaaaaa&orderAscending=true&filter=published eq true&skip=0&sortColumn=customProperties.definition.name eq test&take=20
 
Some informations: 
a snippet of the body of the POST: 
 
{ "name": "customProperties", "columnType": "List", "definition": "CustomPropertyValue",
           "list": [
               { "name": "id", "columnType": "Property", "definition": "id" },
               { "name": "createdDate", "columnType": "Property", "definition": "createdDate" },
               { "name": "modifiedDate", "columnType": "Property", "definition": "modifiedDate" },
               { "name": "modifiedByUserName", "columnType": "Property", "definition": "modifiedByUserName" },
               { "name": "value", "columnType": "Property", "definition": "value" },
               { "name": "definition", "columnType": "Property", "definition": "definition" },
               { "name": "name", "columnType": "Property", "definition": "definition.name" }
           ]
  }
1 Reply
NadiaB
Support
Support

Hi @wellington1

 

Do you mean flter? It would be just 

customProperties.definition.name eq 'custom_property_name'

 

The sortcolumn is to sort a property 

 

https://help.qlik.com/en-US/sense-developer/May2021/Subsystems/RepositoryServiceAPI/Content/Sense_Re...

 

Hope it helps.

 

 

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm