Hi All,
I have difficulty in following logic. If employee having any 1 status as “Skills Approved by Manager” out of below (Case3) skill status then I want to set the status as “Skills Approved by Manager”.
If employee having any 1 status as “Skills Submitted for Approval” out of below (Case 2) skill status then I want to set the status as “Skills Approved by Manager”.
Otherwise “ Save As Draft”.
| Skill Status | Set Skill Status as below |
Case 1 | Skills Approved by Manager | Skills Approved by Manager |
Skills Submitted for Approval |
Save As Draft |
| | |
Case 2 | Skills Submitted for Approval | Skills Submitted for Approval |
| Save As Draft |
| | |
Case 3 | Save As Draft | Save As Draft |
| | |
Examples:-
Case 1 |
EmpId | Skill Status | LastUpdatedDate | Expected Result |
1 | Save As Draft | 10/07/2014 | Skills Approved by Manager |
1 | Save As Draft | |
1 | Skills Approved by Manager | 05/07/2014 |
1 | Skills Submitted for Approval | 05/07/2014 |
Case 2 |
EmpId | SkillStatus | LastUpdatedDate | Expected Result |
2 | Save As Draft | 10/07/2014 | Skills Submitted for Approval |
2 | Save As Draft | |
2 | Skills Submitted for Approval | 05/07/2014 |
Case 3 |
EmpId | SkillStatus | LastUpdatedDate | Expected Result |
3 | Save As Draft | 10/07/2014 | Save As Draft |
3 | Save As Draft | |
Please suggest me if you have any logic.
Thanks & Regards
Sagar Kharpude