Double Rows coming in Report for Single Employee who have been assigned Same Course Multiple times — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Double Rows coming in Report for Single Employee who have been assigned Same Course Multiple times

edited Apr 16, 2019 6:50AM in Learning

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. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!