Exclude records based on the event date of Broadlog | Community
Skip to main content
Level 5
May 20, 2024
Solved

Exclude records based on the event date of Broadlog

  • May 20, 2024
  • 1 reply
  • 685 views

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.

 

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 Craig_Thonis

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.

1 reply

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
May 20, 2024

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.