The client would like to use fields that were built as formulas in some segments. What we noticed is that when we perform the query using SQL x Outbound Segment x Real-Time Segment we obtain three different values.

A ticket was created with Dynamics support and we were informed that "Unfortunately, Outbound Marketing does not support such fields (calculated fields) as they always have the value, that was valid during the last sync (when other fields on this entity were changed)"

I believe that this should be urgently reviewed, as once there is the possibility of creating these fields, they should bring the corresponding values in the query

Field Example:

Pet Age Years: RoundDown((If(DateAdd(Now(),-1*DateDiff('Birth Date',Now(),TimeUnit.Months),TimeUnit.Months) >= 'Birth Date',DateDiff('Birth Date',Now(),TimeUnit.Months),DateDiff('Birth Date',Now(),TimeUnit.Months)-1)/12.00),0)

My Query:

SELECT COUNT(*)

FROM contact c

WHERE 

  (c.test_specieshierarchy = 1 AND c.test_petageyears > 2)

Result:

SQL 3.013.237

Outbound 2.996.729

Real-Time 3.008.879