CMIS: Unable to find documents in a folder

[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.

[robin_clarke]

Thanks.