topic Open CMIS cm:category not consistent? in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/open-cmis-cm-category-not-consistent/m-p/52791#M19823 <HTML><HEAD></HEAD><BODY><P>I try to update categories on folder using java CMIS api and I had a little surprise:</P><P>when I set the category I have to provide the alfcmis:nodeRef, but when I browse categories I retrieve cmis<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />bjectId and so in order to update categories I have to change all the list .</P><P>Isn't there a simpler way to do it? (I mean retrieving the same kind of information I provide to create)</P><P></P><P>I use apache opencmis java client version 1.1.0 and I request information upon an Alfresco community Edition 5.2.0</P><P></P><PRE style="background-color: #2b2b2b; color: #a9b7c6; font-family: 'DejaVu Sans Mono'; font-size: 11.3pt;"><PRE style="background-color: #2b2b2b; color: #a9b7c6; font-family: 'DejaVu Sans Mono'; font-size: 11.3pt;"><SPAN style="color: #cc7832;">public </SPAN>String <SPAN style="color: #ffc66d;">getCategoryRefByOid</SPAN>(String catOid){<BR />&nbsp;&nbsp;&nbsp; ItemIterable&lt;QueryResult&gt; query = <SPAN style="color: #9876aa;">session</SPAN>.query(String.<SPAN style="font-style: italic;">format</SPAN>(<SPAN style="color: #6a8759;">"select * from cm:category where cmis:objectId = '%s'"</SPAN><SPAN style="color: #cc7832;">, </SPAN>catOid)<SPAN style="color: #cc7832;">, false</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; if</SPAN>(query.getTotalNumItems()!=<SPAN style="color: #6897bb;">0</SPAN>) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; QueryResult next = query.iterator().next()<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>String propertyValueById = next.getPropertyValueById(<SPAN style="color: #6a8759;">"alfcmis:nodeRef"</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return </SPAN>propertyValueById<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>}<BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #cc7832;">return null;</SPAN></PRE><PRE style="background-color: #2b2b2b; color: #a9b7c6; font-family: 'DejaVu Sans Mono'; font-size: 11.3pt;"><SPAN style="color: #cc7832;">public void </SPAN><SPAN style="color: #ffc66d;">addCategoryToFolder</SPAN>(Folder parent, String categObjectId){<BR />List&lt;String&gt; catIds = parent.getPropertyValue(<SPAN style="color: #6a8759;">"cm:categories"</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">if</SPAN>(catIds==<SPAN style="color: #cc7832;">null</SPAN>|| catIds.isEmpty())<BR />&nbsp;&nbsp;&nbsp; catIds = <SPAN style="color: #cc7832;">new </SPAN>ArrayList&lt;&gt;()<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">if</SPAN>(!catIds.contains(categObjectId)){<BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #808080;">//catIds contains cmis:objectId instead of alfcmis:nodeRef so transform</SPAN><BR /><SPAN style="color: #808080;">&nbsp;&nbsp;&nbsp; </SPAN>List&lt;String&gt; newCatIds = catIds.stream().map(oid -&gt; getCategoryRefByOid(oid)).collect(Collectors.<SPAN style="font-style: italic;">toList</SPAN>())<SPAN style="color: #cc7832;">;</SPAN><BR />&nbsp;&nbsp;&nbsp; newCatIds.add(getCategoryRefByOid(enginOid))<SPAN style="color: #cc7832;">;</SPAN><BR />&nbsp;&nbsp;&nbsp; HashMap&lt;String<SPAN style="color: #cc7832;">,</SPAN>Object&gt; updated = <SPAN style="color: #cc7832;">new </SPAN>HashMap&lt;&gt;()<SPAN style="color: #cc7832;">;</SPAN><BR /><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>updated.put(<SPAN style="color: #6a8759;">"cm:categories"</SPAN><SPAN style="color: #cc7832;">, </SPAN>newCatIds)<SPAN style="color: #cc7832;">;</SPAN><BR /><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>parent.updateProperties(updated<SPAN style="color: #cc7832;">, true</SPAN>)<SPAN style="color: #cc7832;">;</SPAN><BR /><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>System.<SPAN style="color: #9876aa; font-style: italic;">out</SPAN>.println(<SPAN style="color: #6a8759;">"categ added"</SPAN>)<SPAN style="color: #cc7832;">;</SPAN><BR />}<SPAN style="color: #cc7832;">else</SPAN>{ System.<SPAN style="color: #9876aa; font-style: italic;">out</SPAN>.println(<SPAN style="color: #6a8759;">"categ ok"</SPAN>)<SPAN style="color: #cc7832;">;</SPAN>}</PRE></PRE></BODY></HTML> Tue, 27 Feb 2018 10:25:18 GMT frenout 2018-02-27T10:25:18Z Open CMIS cm:category not consistent? https://connect.hyland.com/t5/alfresco-forum/open-cmis-cm-category-not-consistent/m-p/52791#M19823 I try to update categories on folder using java CMIS api and I had a little surprise:when I set the category I have to provide the alfcmis:nodeRef, but when I browse categories I retrieve cmis<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />bjectId and so in order to update categories I have to change all the list .Isn't there a simpler way to d Tue, 27 Feb 2018 10:25:18 GMT https://connect.hyland.com/t5/alfresco-forum/open-cmis-cm-category-not-consistent/m-p/52791#M19823 frenout 2018-02-27T10:25:18Z Re: Open CMIS cm:category not consistent? https://connect.hyland.com/t5/alfresco-forum/open-cmis-cm-category-not-consistent/m-p/52792#M19824 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>That is an interesting one. Clearly the repository is mapping node references to cmis objectIds&nbsp; for that particular property type. It should do the reverse mapping at set time. This sounds like a bug to me. Please raise this as an ALF issue in Jira.</P><P></P><P>Andy</P></BODY></HTML> Thu, 01 Mar 2018 16:44:01 GMT https://connect.hyland.com/t5/alfresco-forum/open-cmis-cm-category-not-consistent/m-p/52792#M19824 andy1 2018-03-01T16:44:01Z