how to add sysfilters or filters in schema with conditions in adobe campaign classic | Community
Skip to main content
S
Shruti1
Level 4
October 22, 2024
Solved

how to add sysfilters or filters in schema with conditions in adobe campaign classic

  • October 22, 2024
  • 1 reply
  • 813 views

Hi All,

I need to add sysfilters or filters in schema with conditions in adobe campaign please suggest

 

filter : nt_creation_dt > current_date – 365 AND nt_provider_id = ‘elc’

 

thanks in advance

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ccg1706

Hi @shruti1, 

 

You can use the following documentation to help you to solve the issue: Filter creation and Sysfilter element

For the creation, you should insert the filter inside the schema you want to apply it, editing its XML under (Administration>Configuration>Data Schemas). You can try this solution to guide you:

 

<sysFilter name="customFilter"> <condition expr="@nt_creation_dt > (GetDate() - 365) AND @nt_provider_id = 'elc'"/> </sysFilter>

 

Regards, 

Celia

 

 

 

1 reply

ccg1706
Community Advisor
ccg1706Community AdvisorAccepted solution
Community Advisor
October 24, 2024

Hi @shruti1, 

 

You can use the following documentation to help you to solve the issue: Filter creation and Sysfilter element

For the creation, you should insert the filter inside the schema you want to apply it, editing its XML under (Administration>Configuration>Data Schemas). You can try this solution to guide you:

 

<sysFilter name="customFilter"> <condition expr="@nt_creation_dt > (GetDate() - 365) AND @nt_provider_id = 'elc'"/> </sysFilter>

 

Regards, 

Celia

 

 

 

    Terms & ConditionsAccessibility statement

    Loading footer...