Double Rows coming in Report for Single Employee who have been assigned Same Course Multiple times
Content
Hi,
I have attached a Query where Single Employee who have been assigned Course "2000_Make Our Customers Love Landmark_L&G_BFL" multiple times by Same Admin/Different Admin is appearing multiple times in the query(all effective dated conditions are properly done, to get active row).
For example:
HRMS id 143658 has two rows one "In Progress" another "Pending Active".
The Assigned By is by two different Learn Admin.
Where as in the frontend 1 row is showing i.e "In Progress"
Please suggest what should be done to get the rows in the Query as its coming in Frontend.