- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Labels:
-
Alfresco Content Services
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-22-2021 04:51 AM
Did you try the "orderBy" parameter?
https://api-explorer.alfresco.com/api-explorer/#/nodes/listNodeChildren
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-22-2021 05:00 AM
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"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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'\''" } }'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-27-2021 04:49 AM
unfortunately it does not seem to be possible to search a term inside properties property.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-27-2021 05:49 AM
It's possible, but using the Search REST API with ANCESTOR.