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

[Shruti1]

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

[ccg1706 · Accepted solution]

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