Searching documents using CMIS query in a Folder hierarchy

[arpit_gupta]

Hello Friends,

Right now i am searching my documents with CMIS query and a custom webscript.
My web script looks like…

var cmisConnection = cmis.getConnection();
var cmisSession    = cmisConnection.getSession();
var results = cmisSession.query(query, false); 
‍‍‍‍‍

this script search the documents in all the folders, but i want to search in particular folder and it's sub folders.
I can search document in particular folder by adding parent check in the CMIS query but i can not search in it's sub folders as a document only
contains parent information not the root folder information.

Is there any way to search documents in a folder hierarchy??

Thanks,
Arpit

[mitpatoliya]

You can use the path query for that.
Which helps you to narrow down your search.

[arpit_gupta]

Thanks for ur reply.

i have added path in my query like—

select * from my:documents where contains('PATH:"/app:company_home/app:user_homes/cm:my_home_folder"')

but it return me 0 documents though i have some documents in the folder.
i am not sure what am i missing.
Can someone please help me out.

Thanks,
Arpit

[mitpatoliya]

Yes, you missed *
it should be like this
'PATH:"/app:company_home/app:user_homes/cm:my_home_folder/*"'

[arpit_gupta]

Thanks dear..
it helped..

select * from my:documents where contains('PATH:"/app:company_home/app:user_homes/cm:my_home_folder/*"'')

with the above query i can search all the documents in my_home_folder though still i can not search documents in it's sub-folders.

i modified my query for searching in it's immediate sub folders like

select * from my:documents where contains('PATH:"/app:company_home/app:user_homes/cm:my_home_folder/*/*"')