AnsweredAssumed Answered

complex conditions in virtual folder

Question asked by fararjeh on Feb 26, 2014
Latest reply on Feb 26, 2014 by fararjeh
Hi,


How I can build structure query in virtual folder xml file for this query :
cmis:folder.cmis:createdBy = 'fararjeh' and ( F:re:requestForm.re:purchasingManagerStatus ='approve' or F:re:requestForm.re:employeeStatus = 'done')

This is virtual folder xml file:


<node name="طلبات قيد التحضير" containsdocs="true">
   <search versionselection="currentversion">
      <from>
         <class symname="folder" />
      </from>
      <select>
         <selectprops>
            <selectprop symname="F:re:requestForm.re:employeeStatus" />
            <selectprop symname="F:re:requestForm.re:mangerStatus" />
            <selectprop symname="F:re:requestForm.re:purchasingManagerStatus" />                  
            <selectprop symname="F:re:requestForm.re:employeeName" />
            <selectprop symname="F:re:requestForm.re:employeeId" />
            <selectprop symname="F:re:requestForm.re:titleJop" />
            <selectprop symname="F:re:requestForm.re:mobileNumber" />
            <selectprop symname="F:re:requestForm.re:branchName" />
            <selectprop symname="F:re:requestForm.re:management" />
            <selectprop symname="F:re:requestForm.re:notes" />                  
         </selectprops>
      </select>
      <where>
         <and>
            <eq>
               <whereprop editproperty="hidden" symname="cmis:folder.cmis:createdBy"/>
               <literal>{username}</literal>
            </eq>         
            <eq>
            <whereprop editproperty="hidden" symname="F:re:requestForm.re:purchasingManagerStatus" />
               <literal>approve</literal>
            </eq>
            <eq>
               <whereprop editproperty="hidden" symname="F:re:requestForm.re:employeeStatus"/>
               <literal>done</literal>
            </eq>   
         </and>               
      </where>               
      <subclasses>
         <subclass objecttype="folder" symname="F:re:requestForm" />
      </subclasses>
   </search>
</node>

Outcomes