Alert Composer: Trigger a Notification when the LPM Person EIT is added to an employee

Hi Team,

We have the following scenario and would like to understand if it’s achievable using a Resource Alert in Alerts Composer:

We want to trigger a notification when the LPM Person EIT is added to an employee, but only if the effective dates of that LPM overlap with any existing Leave of Absence for the same employee.

Could you please confirm if this logic can be implemented using Alerts Composer?

We're evaluating whether this approach is feasible or if we should consider a report-based solution instead.

Thanks,

Mahi.