Custom resource alert created using alert composer not working properly
Summary: Custom resource alert created using alert composer not working properly
Content (please ensure you mask any confidential information):
Below is the filter added:
EXISTS (SELECT 'x' FROM PER_ALL_ASSIGNMENTS_M T1,PER_PERIODS_OF_SERVICE T2 WHERE T1.PERIOD_OF_SERVICE_ID = T2.PERIOD_OF_SERVICE_ID AND T1.Assignment_Type ='E' AND TRUNC(T1.PROJECTED_ASSIGNMENT_END)>=TRUNC(SYSDATE) AND T1.assignment_status_type = 'ACTIVE' AND sysdate BETWEEN T1.effective_start_date AND T1.effective_end_date AND T2.person_id = ${PersonId} )
Even I have added specifically
Assignment_Type ='E' & assignment_status_type = 'ACTIVE' in the filter then also