10-22-2021 04:50 AM
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.
10-22-2021 06:01 AM
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
10-22-2021 04:51 AM
Did you try the "orderBy" parameter?
https://api-explorer.alfresco.com/api-explorer/#/nodes/listNodeChildren
10-22-2021 05:00 AM
in the doc the available orderBy fields are:
but I need to order by a property inside "properties"
10-22-2021 06:01 AM
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
10-22-2021 06:36 AM
yes it works!
I think it is a serious shortcoming that such an important thing is not indicated in the documentation.
Anyway thanks!!!
10-26-2021 12:04 PM
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.
10-27-2021 03:25 AM
Where filter is not designed to accept that kind of expressions. Mainly Where syntax is described in
You need to use Search REST API in order to apply filters based in custom properties.
10-27-2021 03:30 AM
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'\''" } }'
10-27-2021 04:49 AM
unfortunately it does not seem to be possible to search a term inside properties property.
10-27-2021 05:49 AM
It's possible, but using the Search REST API with ANCESTOR.
Explore our Alfresco products with the links below. Use labels to filter content by product module.