AnsweredAssumed Answered

CMIS: Unable to find documents in a folder

Question asked by robin.clarke on May 30, 2014
Latest reply on Jun 2, 2014 by 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>cmis:path: /Sites/Regulation/EMIR/White Papers</strong>
cmis:objectTypeId: 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
cmis:objectId: 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=?]
cmis:parentId: workspace://SpacesStore/fad0a436-8288-431f-8852-b55e4f519a60


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

Outcomes