Skip to main content
Level 4
Oct 21, 2024 4:40 AM UTC
Solved

Query about Sysfilters in Adobe campaign classic

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ccg1706
ccg1706Accepted solution
Community Advisor and User Group Leader
Oct 21, 2024 8:50 AM UTC

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

1 reply

ccg1706
Community Advisor and User Group Leader
ccg1706Community Advisor and User Group LeaderAccepted solution
Community Advisor and User Group Leader
Oct 21, 2024 8:50 AM UTC

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

Translate