SOLVED

Constraints on Changed Data Value filters (filter constraint order)

Go to solution
JasonSantoMF
Level 2

Constraints on Changed Data Value filters (filter constraint order)

Hello,

I've perused documentation and message board posts, but I cannot find what I think should be a remedial explanation of in what order the constraints are evaluated within filtering. 

 

Is the order of the constraints the evaluation order used by Marketo to qualify records?


I've got a Changed Data Value filter that looks at Source and then I want it to look at Date of Activity:

Data Value Changed attribute IS Lead Source

Source IS NOT "List import" 
Activity IS in past 30 minutes. 

I'm reading this as anything that wasn't a list import in the last 30 minutes will qualify. But is that correct? Because I could see this also as anything in the last 30 minutes that wasn't a list import will qualify, which means in order to qualify, the data value change would have had to have happened within the past 30 minutes.

 

I know I could probably run some tests to figure this out, but I appreciate any thoughts people might offer - or a link to documentation on the topic. 

Thank you. 

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Constraints on Changed Data Value filters (filter constraint order)

The order doesn't matter! (And is ultimately up to the database implementation, as it's assembled into a SQL query.)

 

The result must the same regardless of which is eval’d first – it's an AND between flat fields.

View solution in original post

1 REPLY 1
SanfordWhiteman
Level 10 - Community Moderator

Re: Constraints on Changed Data Value filters (filter constraint order)

The order doesn't matter! (And is ultimately up to the database implementation, as it's assembled into a SQL query.)

 

The result must the same regardless of which is eval’d first – it's an AND between flat fields.