Removal of old Segmentation/Query

Avatar

Avatar

jae_lee

Avatar

jae_lee

jae_lee

28-02-2017

In our system, we have some queries/segments set up that are looking for a particular value.  

You’ll see a query looking for "Is User Valid’ @IsUserValid = 1":

This code/logic is apparently a left over from when we were using Aprimo and it is an old piece of logic that no longer applies.  If queries are set up like this, they are not picking up new contacts in the system that do not have this value set to 1.  

We are wondering if there is an easy way to either remove this field system-wide or will we need to go into each filter/segment, etc and look for this logic and remove it from where it exists?

Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

unifica

Avatar

unifica

unifica

01-03-2017

Hi Jae,

A script could be written to achieve this by looping through all workflows and modifying the WHERE clause within each Query object.
However, I wouldn't describe it as being an 'easy way'. You may find it quicker to perform the task manually.

Thanks,

Jordan Dolan - Adobe Campaign Consultant

Answers (5)

Answers (5)

Avatar

Avatar

jae_lee

Avatar

jae_lee

jae_lee

01-03-2017

Thank you.

Jae

Avatar

Avatar

jae_lee

Avatar

jae_lee

jae_lee

01-03-2017

Thank you.

Jae

Avatar

Avatar

jae_lee

Avatar

jae_lee

jae_lee

01-03-2017

Thank you.

Jae

Avatar

Avatar

alistairk396804

Avatar

alistairk396804

alistairk396804

01-03-2017

Depending on how many workflows you currently have it may just be quicker and easier to set aside an hour or two and manually remove them.

Avatar

Avatar

Vapsy

Employee

Avatar

Vapsy

Employee

Vapsy
Employee

01-03-2017

Hi Jae,

You can modify the schema column and apply default constraint to be as 1 instead of 0.

every new record will get created as isValid=1

Other thing is to modify your workflow that inserts new recipients and ensure that isValid field is configured to be set to 1.