Need to add filters at Schema level in Schema Edit Tab in Adobe Campaign Classic | Community
Skip to main content
S
Shruti1
Level 4
October 25, 2024
Solved

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

  • October 25, 2024
  • 1 reply
  • 592 views

 

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

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,

 

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

 

 

 

 

1 reply

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

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

 

 

 

 

    Terms & ConditionsAccessibility statement

    Loading footer...