topic Re: Rest API, How to getChildren and orderBy a properties in Alfresco Forum

Rest API, How to getChildren and orderBy a properties

danny36 — Fri, 22 Oct 2021 08:50:32 GMT

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.

Re: Rest API, How to getChildren and orderBy a properties

angelborroy — Fri, 22 Oct 2021 08:51:56 GMT

Did you try the "orderBy" parameter?

https://api-explorer.alfresco.com/api-explorer/#/nodes/listNodeChildren

Re: Rest API, How to getChildren and orderBy a properties

danny36 — Fri, 22 Oct 2021 09:00:06 GMT

in the doc the available orderBy fields are:

isFolder
name
mimeType
nodeType
sizeInBytes
modifiedAt
createdAt
modifiedByUser
createdByUser

but I need to order by a property inside "properties"

Re: Rest API, How to getChildren and orderBy a properties

angelborroy — Fri, 22 Oct 2021 10:01:55 GMT

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

Re: Rest API, How to getChildren and orderBy a properties

danny36 — Fri, 22 Oct 2021 10:36:50 GMT

yes it works!

I think it is a serious shortcoming that such an important thing is not indicated in the documentation.

Anyway thanks!!!

Re: Rest API, How to getChildren and orderBy a properties

danny36 — Tue, 26 Oct 2021 16:04:34 GMT

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.

Re: Rest API, How to getChildren and orderBy a properties

angelborroy — Wed, 27 Oct 2021 07:25:27 GMT

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.

Re: Rest API, How to getChildren and orderBy a properties

angelborroy — Wed, 27 Oct 2021 07:30:33 GMT

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

Re: Rest API, How to getChildren and orderBy a properties

danny36 — Wed, 27 Oct 2021 08:49:13 GMT

unfortunately it does not seem to be possible to search a term inside properties property.

Re: Rest API, How to getChildren and orderBy a properties

angelborroy — Wed, 27 Oct 2021 09:49:20 GMT

It's possible, but using the Search REST API with ANCESTOR.