topic CMIS aspect query with path in Alfresco Forum

CMIS aspect query with path

alfresco_one — Fri, 17 Mar 2017 14:33:33 GMT

Hi all,I need to query a particular folder in the repository using a java based scheduler in alfresco.I need to check whether the custom aspect's property is present or not. Below query works for me when I don't use the path query.select * from myType:caseDoc as d join myAspect:caseId as s on d.cmis

Re: CMIS aspect query with path

jpotts — Fri, 07 Sep 2018 20:09:05 GMT

Old post, but the problem here is explained by the exception: the selector is missing.

The fix is to add it. Change:

WHERE CONTAINS('PATH:"//app:company_home/cm:FDLE/cm:CCH/cm:CCH-DROP-FOLDER/*"')

to:

WHERE CONTAINS(d, 'PATH:"//app:company_home/cm:FDLE/cm:CCH/cm:CCH-DROP-FOLDER/*"')