Hello All,
I am stuck in a requirement where I have to create sysfilters in schema like this:
IF brand = 0 then 999999 else table1.BRANCH_ID =table.iBrandId
Please suggest how can we create sysfilters in schema like this
please give some guidance
Hi @shruti1,
I share with you a useful documentation link, that can help you to clarify your issue.
Try with these two options inside the XML schema where you need the filter:
A:
<sysFilter>
<expr>
<![CDATA[
(@brand=0 and @branchId=999999) or (@brand!=0 and @branchId=table1.BRANCH_ID)
]]>
</expr>
</sysFilter>B:
<sysFilter>
<expr>
<![CDATA[
([@brand=0] and 999999) or ([@brand!=0] and @branchId=table1.BRANCH_ID)
]]>
</expr>
</sysFilter>
Regards,
Celia
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.