OTBI Report: Interaction note - Start Date Change

Summary:

We tried to create a report which includes the field Interaction note = Start Date Change, has anyone created one that works?

Content (required):

We tried to create a report which includes the field Interaction note = Start Date Change, has anyone created one that works?

The report goal is to create a report to capture candidates with start date changes. Currently, the only way of capturing that is to add an interaction note - Start Date Change and that is where we are struggling.

Issues:

1. When the candidate has multiple entries for start date change we add MAX in the interaction note start date change creation date (MAX(CASE WHEN "Job Application - Interaction Note"."Interaction Type" = 'Start Date Change' then "Job Application - Interaction Note"."Creation Date" else null end)) and in pulling the text in interaction note = text (MAX(CAST(CASE WHEN "Job Application - Interaction Note"."Interaction Type" = 'Start Date Change' then "Job Application - Interaction Note"."Text" end AS VARCHAR(4000))))