Need to add filters at Schema level in Schema Edit Tab in Adobe Campaign Classic

[Shruti1]

Hello All,

I Need to add filters at Schema level in Schema in Edit Tab in Adobe Campaign Classic

Filter : trp_creation_dt > current_date – 365 AND trp_provider_id = ‘mcd’

Please suggest something, this is really urgent, Kindly add your thoughts and references

[ccg1706]

HI @Shruti1,

I share with you some useful documentation links:

- Creating filters

- Functions

(Functions link, goes to Standard documentation but the majority of them can be applied to classic)

Additionally, I give you a possible solution as a guidance, to solve your issue. Add it inside your schema under Administration/Configuration/Data Schemas.

<sysFilter name="customFilter">
    <condition expr="@trp_creation_dt > (GetDate() - 365) AND @trp_provider_id = 'mcd'"/>
</sysFilter>

The GetDate () function here helps us to get the current date minus 365 days allowing us to be more precise when filtering.

Regards, 

Celia