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.