Hello,
I need if possibile to order a list of nodes returned from getChildren api call by one of a properties.
In the rest api doc it is not mentioned.
thanks.
This is working for me:
http://127.0.0.1:8080/alfresco/api/-default-/public/alfresco/versions/1/nodes/8bb36efb-c26d-4d2b-9199-ab6922f53c28/children?skipCount=0&maxItems=100&orderBy=cm%3Atitle
I guess you can use the same approach with your custom property name wbase%3AcognomeRubrica
Did you try the "orderBy" parameter?
https://api-explorer.alfresco.com/api-explorer/#/nodes/listNodeChildren
in the doc the available orderBy fields are:
but I need to order by a property inside "properties"
yes it works!
I think it is a serious shortcoming that such an important thing is not indicated in the documentation.
Anyway thanks!!!
Hi,
and if I want to retrive a set of items based on a property inside properties? I tray filter:
where=(wbase%3AtipologiaRubrica=1)
but don't works.
Where filter is not designed to accept that kind of expressions. Mainly Where syntax is described in
https://github.com/Alfresco/alfresco-community-repo/blob/master/remote-api/src/main/java/org/alfresco/rest/api/Nodes.java#L399
You need to use Search REST API in order to apply filters based in custom properties.
For instance, this REST API call will retrieve all the children from a parent folder (ANCESTOR) having the property cm:title with "Title" value:
curl --location --request POST 'http://localhost:8080/alfresco/api/-default-/public/search/versions/1/search' \ --header 'Authorization: Basic YWRtaW46YWRtaW4=' \ --header 'Content-Type: application/json' \ --data-raw '{ "query": { "query": "ANCESTOR:'\''workspace://SpacesStore/0f90a538-10d3-4f3f-9a9c-431e674a4f89'\'' AND cm:title:'\''Title'\''" } }'
unfortunately it does not seem to be possible to search a term inside properties property.
