topic Re: How to update properties through CMIS in Alfresco Forum

How to update properties through CMIS

ArlindoViana — Thu, 13 Aug 2020 13:55:29 GMT

Hello guys,

How can I update properties of several documents at once, for example using:

UPDATE cm: indexControl SET cm: isIndexed = true, cm: isContentIndexed = true WHERE cm: isIndexed = false AND cm: isContentIndexed = false AND cmis: objectTypeId = 'D: sij: documento'

sij:documento is a custom type on my data model.

Re: How to update properties through CMIS

dvuika — Thu, 13 Aug 2020 13:56:58 GMT

You probably need to raise this question in the Content Services forum.

Re: How to update properties through CMIS

kaynezhang — Thu, 13 Aug 2020 16:07:58 GMT

You can try to query all the objects that you are trying to change properties by queryObjects method of org.apache.chemistry.opencmis.client.api.Session an then call bulkUpdateProperties method of org.apache.chemistry.opencmis.client.api.Session

Re: How to update properties through CMIS

angelborroy — Thu, 13 Aug 2020 16:29:26 GMT

CMIS is a standard that provides a subset of SQL-92 for discovering objects, but not for modifying them.

http://docs.oasis-open.org/cmis/CMIS/v1.1/os/CMIS-v1.1-os.html#x1-10500014

You need to use other approach like suggested above to update your Repository Nodes.

Re: How to update properties through CMIS

ArlindoViana — Thu, 13 Aug 2020 17:58:00 GMT

solved with this tip from Apache Chemitry Samples: https://chemistry.apache.org/docs/cmis-samples/samples/update-objects/index.html

Many thanks for all.

Re: How to update properties through CMIS

EddieMay — Fri, 14 Aug 2020 08:55:56 GMT

Hi @ArlindoViana,

Glad you got a solution & thanks for the reference - really helpful to other users.

Best wishes,