topic Re: Searching documents using CMIS query in a Folder hierarchy in Alfresco Archive

Searching documents using CMIS query in a Folder hierarchy

arpit_gupta — Mon, 16 Apr 2012 07:58:17 GMT

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 t

Re: Searching documents using CMIS query in a Folder hierarchy

mitpatoliya — Mon, 16 Apr 2012 10:22:28 GMT

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

Re: Searching documents using CMIS query in a Folder hierarchy

arpit_gupta — Mon, 16 Apr 2012 14:05:44 GMT

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

Re: Searching documents using CMIS query in a Folder hierarchy

mitpatoliya — Tue, 17 Apr 2012 04:11:49 GMT

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

Re: Searching documents using CMIS query in a Folder hierarchy

arpit_gupta — Tue, 17 Apr 2012 07:57:20 GMT

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/*/*"')