Query about Sysfilters in Adobe campaign classic

[Shruti1]

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

[ccg1706 · Accepted solution]

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