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

[shantprai]

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  cmisath LIKE 'vcr12-Dummy/vcr12'";

but it is showing internal server error problem.

[sujaypillai]

Hello,

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

[shantprai]

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/cmn-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/cmn-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