CMIS: Unable to find documents in a folder

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

robin_clarke

Hi,
I am trying to use CMIS to find all the documents in a folder, but not having any luck. I would like to do something like this, but it is not working.

SELECT * FROM cmis:document WHERE CONTAINS('PATH:"/Sites/Regulation/EMIR/White Papers"')
‍‍‍

The path seems correct, according to the results of this query:

SELECT * FROM cmis:folder WHERE cmis:objectId = 'workspace://SpacesStore/d019c335-dcdc-4023-aa10-7cee600aa5b4'
‍‍‍

cmis:allowedChildObjectTypeIds: null
<strong>cmisath: /Sites/Regulation/EMIR/White Papers</strong>
cmisbjectTypeId: cmis:folder
cmis:name: White Papers
cmis:creationDate: java.util.GregorianCalendar[time=?,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT+01:00",offset=3600000,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=2,minimalDaysInFirstWeek=4,ERA=?,YEAR=2014,MONTH=4,WEEK_OF_YEAR=?,WEEK_OF_MONTH=?,DAY_OF_MONTH=29,DAY_OF_YEAR=?,DAY_OF_WEEK=?,DAY_OF_WEEK_IN_MONTH=?,AM_PM=?,HOUR=?,HOUR_OF_DAY=16,MINUTE=50,SECOND=46,MILLISECOND=341,ZONE_OFFSET=?,DST_OFFSET=?]
cmis:changeToken: null
cmis:secondaryObjectTypeIds: null
cmis:lastModifiedBy: admin
cmis:createdBy: admin
cmisbjectId: workspace://SpacesStore/d019c335-dcdc-4023-aa10-7cee600aa5b4
alfcmis:nodeRef: null
cmis:baseTypeId: cmis:folder
cmis:description: null
cmis:lastModificationDate: java.util.GregorianCalendar[time=?,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT+01:00",offset=3600000,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=2,minimalDaysInFirstWeek=4,ERA=?,YEAR=2014,MONTH=4,WEEK_OF_YEAR=?,WEEK_OF_MONTH=?,DAY_OF_MONTH=29,DAY_OF_YEAR=?,DAY_OF_WEEK=?,DAY_OF_WEEK_IN_MONTH=?,AM_PM=?,HOUR=?,HOUR_OF_DAY=17,MINUTE=8,SECOND=1,MILLISECOND=810,ZONE_OFFSET=?,DST_OFFSET=?]
cmisarentId: workspace://SpacesStore/fad0a436-8288-431f-8852-b55e4f519a60


How can I query for all the document in a folder, using the path?

kaynezhang

Your path format is not correct ,you can view the PATH format using node browser.

Here is an example

SELECT * FROM cmis:folder WHERE CONTAINS('PATH:"/app:company_home/st:sites/cm:Regulation/cm:EMIR/cm:White_x0020_Papers//*"')
‍‍‍

And make sure encode some path elements with ISO9075.encode  method (for your example White Papers will be encoded to White_x0020_Papers),or you will get ParseException.