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

wellington1 — Fri, 29 Oct 2021 03:50:20 GMT

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" }

]

}

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

NadiaB — Mon, 08 Nov 2021 21:02:15 GMT

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_RepositoryServiceAPI/RepositoryServiceAPI-Table-Pagination.htm

Hope it helps.

topic Re: Theres a way to sort a table by name of custom property with QRS API ? in Integration, Extension & APIs

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

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