Constraints on Changed Data Value filters (filter constraint order) | Community
Skip to main content
JasonSantoMF
New Participant
December 7, 2023
Solved

Constraints on Changed Data Value filters (filter constraint order)

  • December 7, 2023
  • 1 reply
  • 1110 views

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. 

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 SanfordWhiteman

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.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
December 7, 2023

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.