Skip to main content

Hello community,

When creating a SQL query and creating the XML to consult through the FSM XML Poster, I have not managed to make the parens element work since the where contains and and or clauses.

how can I do?

 

Thanks.

Hi @Yonatha , 

 

See example below:

<hierarchy_select>
  <primary_table>request</primary_table>
  <attrs>
    <attr>request.request_id</attr>
    <attr>request.req_status</attr>
  </attrs>
  <from>
    <table>request</table>
  </from>
  <where>
    <data_constraint>
      <parens>
        <constraint>
          <left_operand>request.status</left_operand>
          <operator>eq</operator>
          <right_operand>HO</right_operand>
        </constraint>
        <or />
        <constraint>
          <left_operand>request.status</left_operand>
          <operator>eq</operator>
          <right_operand>CA</right_operand>
        </constraint>
      </parens>
    </data_constraint>
  </where>
</hierarchy_select>

 

-Ruben

Thank you @ruben.maas 

Terms & ConditionsCookie settings