cancel
Showing results for 
Search instead for 
Did you mean: 

cmis query to search two folder having same name but different parent

shantprai
Champ in-the-making
Champ in-the-making
How to write query to folder level search,I have requirement like two folder having same name i.e.2013 and different parent i.e. test1 and test2 when I clicked on any one of 2013 folder it is giving same output,but we have different folder in both the places in side 2013 foolder ,
how to write the query to do this type of probelm please telll me its urgent for my project I am using 4.2C version of alfresco..


String query =  "SELECT * FROM cmis:folder WHERE  cmisSmiley Tongueath LIKE 'vcr12-Dummy/vcr12'";

but it is showing internal server error problem.
2 REPLIES 2

sujaypillai
Confirmed Champ
Confirmed Champ
Hello,

Check out the query in the attached image. Hope so that helps you.

Hi Sujay,
I have tried this query
SELECT * FROM cmis:folder WHERE CONTAINS('PATH:\"/app:company_home/st:sites/cm:shant test 5-Dummy/cm:shant test 5/cmSmiley Surprisedn-shant-rai/cm:Test Area Two/cm:Y2013\"') "

this is giving internal server error problem where as I have tried other query which folder name does not have space then it is working
i.e
String query = "SELECT * FROM cmis:folder WHERE CONTAINS('PATH:\"/app:company_home/st:sites/cm:srai-Dummy/cm:srai/cmSmiley Surprisedn-going-Compliances/cm:Area-2/cm:Y2013\"') ";

So,please tellme that how we can work with this type folder name which are having space in name ,
It is urgent for me please help me ASAP
Thanks in advance