pls help to get the query for a analytics report where i should get the data like
there are some roles inactive and for those it has approver name, email, emp id
data currently showing reeated times for the inactvie roles with approver name , email ,emp id
user needs those inactive roles and infromation should be shown in one line for a role
current data showing:
| LA ROLE | LA ROLE STATUS | APPROVER FIRSTNAME | APPROVER LASTNAME | APPROVER EMAIL | APPROVER EMPLOYEEID | APPROVER STATUS |
| CSS_EE_Global | InActive | A | AND | A.AND@ | 123 | Active |
| CSS_EE_Global | InActive | BC | VTY | BC.VTY@ | 123 | Active |
| Reporting_AE_Global | InActive | xyz | MNY | xYZ@ | 123 | Active |
| Reporting_AE_Global | InActive | TOR | YRE | TOR@ | 123 | Active |
required data:
It should not show the repeated values for the inactive role , next line data should be in one line , like contactnanate
