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
