Exclude records based on the event date of Broadlog

[rvnth]

Hi Team, 

I wanted to exclude records where the rec create date of feature schema is less than then broad log event date. There was a join between recipient schema and feature schema. First I tried querying the recipient delivery logs by keeping rcipient as target dimension and then later added one more query activity and selected temporary schema as the previous broadlog query activity which is giving me 0 records. Please suggest on how to get the records where the event date is greater than the rec_create_date of feature schema. Thank you in advance. Please can you make me understand how the below query activities why it was fetching 0 records

 

 

I tried something as below by using the filtering dimension as feature schema & targeting dimension as recipient. Will this fetch me the correct amount of records.

[Craig_Thonis · Accepted solution]

Hi rvnth,

If possible, I might suggest using a different field other than the event date. The event date field is subject to asynchronous events, which can update the date. So even if the workflow returns the desired results initially, you may see some irregularities in the results.