About the coreQueryPageProvider and Predicate /fixedPart

brigitte_ — Fri, 25 Jan 2013 17:37:16 GMT

Hello,

I have to query several sub-workspace where there are several types of documents. Each type of theses documents contains one same metadata among others.

So, I can't use element because I understand that there is a AND between each , isn't it ? Unless an OR element is possible ?

I try to use the element but I don't know the syntax to reference the field of my search. I'm in an advanced search.

For example, I can't use that because I want a OR and not a AND :

<predicate parameter="MonTypeA:sitebat" operator="STARTSWITH">
       <field schema="my_advanced_search" name="site" />
</predicate>
 <predicate parameter="MonTypeB:sitebat" operator="STARTSWITH">
       <field schema="my_advanced_search" name="site" />
 </predicate>

And this doesn't ok :

       <fixedPart>
        ecm:isCheckedInVersion = 0 AND
        ecm:currentLifeCycleState != 'deleted' AND
        ( ecm:primaryType = 'MonTypeA' OR
        ecm:primaryType = 'MonTypeB' ) AND
        ( MonTypeA:sitebat STARTSWITH ? OR
          MonTypeB:sitebat STARTSWITH ?)             `) 
      </fixedPart>      
    </whereClause>
      <parameter>my_advanced_search:site</parameter>
      <parameter>my_advanced_search:site</parameter>

The problem comes from the syntax of element : how reference the field "site" of my advanced search ?

Thanks for any help.

Re: About the coreQueryPageProvider and Predicate /fixedPart

brigitte_ — Thu, 07 Feb 2013 17:59:09 GMT

Hello,

I found the solution : searchDocument, obviously !

<fixedPart>
    ecm:isCheckedInVersion = 0 AND
    ecm:currentLifeCycleState != 'deleted' AND
    ( ecm:primaryType = 'MonTypeA' OR
    ecm:primaryType = 'MonTypeB' ) AND
    ( MonTypeA:sitebat STARTSWITH ? OR
      MonTypeB:sitebat STARTSWITH ?) ) 
  </fixedPart>      
</whereClause>
  <parameter>#{searchDocument.my_advanced_search.site}</parameter>
  <parameter>#{searchDocument.my_advanced_search.site}</parameter>

topic Re: About the coreQueryPageProvider and Predicate /fixedPart in Nuxeo Forum

About the coreQueryPageProvider and Predicate /fixedPart

Re: About the coreQueryPageProvider and Predicate /fixedPart

I found the solution : searchDocument, obviously !