Preview results and display logs in transition results are not matching.

[rvnth]

I’ve encountered an unusual scenario where running the full query retrieves around 1,000 records. However, when I manually filter by EID (e.g., EID = xxxxx) with the same additional filters, the records qualify in the preview tab but do not appear when I run the query activity. Specifically, Record A does not show up in the transition display logs.

Additionally, I have a question regarding the following Iif statement:

Iif(AddDays(DateOnly(@COLUMN1), 11) > AddDays(DateOnly(@COLUMN2), 21),
AddDays(DateOnly(@COLUMN1), 11),
AddDays(DateOnly(@COLUMN2), 21))

What happens if COLUMN1 is NULL? When I run this in the backend query, Record A qualifies, but when I run the query activity, Record A does not qualify. Could someone explain why this discrepancy occurs?

Also, could you clarify the behavior when COLUMN1 remains NULL?

It seems like when I have the same record with different EIDs, the query activity picks up the record with the most recent REC_UPDATE_DATE. Can anyone confirm if this is true?

Thank you in advance.

[_Manoj_Kumar_ · Accepted solution]

Hello @rvnth  if the value of @column is null then they won't be considered for the output as they won;t fulfill this condition.