+1
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.
Best answer by ruben.maas
View originalHi
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
+1
Thank you
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
