Hi Folks,
I have below data and i want to show the records based on selection ..so suppose if i select break1 from find ID then i will come to know what are the TreatID and AssetID related to that particular selected break ...and what are the associated items for TreatID and AssetID for selected break 1.
You can see what i want in output below as test cases. How to achive this.
help would be much appreciable. Thanks
| FindID | TreatD | SourceID | Type | Level | Title | AssetID | CountKey |
| ITRC\Break\1 | Unspecified | 1 | Break | Finding | Test Break 1 | 1234 | ITRC\Break\1 |
| ITRC\Break\1 | ITRC\Remedy\1 | 1 | Remedy | Treatment | Test Remedy 1 | 1234 | ITRC\Remedy\1 |
| ITRC\Break\2 | Unspecified | 2 | Break | Finding | Test Break 2 | 3456 | ITRC\Break\2 |
| ITRC\Break\2 | ITRC\Remedy\1 | 1 | Remedy | Treatment | Test Remedy 1 | 3456 | ITRC\Remedy\1 |
| SEAL\SEALDQ\1 | SEAL\SEALDQ\1 | 1 | SEAL DQ | Treatment | Test SEAL DQ 1 | 1234 | SEAL\SEALDQ\1 |
| ITRC\ACA\1 | ITRC\ACA\1 | 1 | ACA | Treatment | Test ACA 1 | 1234 | ITRC\ACA\1 |
| FORCE\Issue\1 | Unspecified | 1 | Issue | Finding | Test Issue 1 | FORCE\Issue\1 | |
| FORCE\Issue\1 | FORCE\Action Plan\1 | 1 | Action Plan | Treatment | Test Action Plan 1 | FORCE\Action Plan\1 | |
| FORCE\Issue\1 | FORCE\Action Plan\2 | 2 | Action Plan | Treatment | Test Action Plan 2 | FORCE\Action Plan\2 | |
| FORCE\Issue\1 | FORCE\Action Plan\3 | 3 | Action Plan | Treatment | Test Action Plan 3 | FORCE\Action Plan\3 | |
| FORCE\Issue\2 | Unspecified | 2 | Issue | Finding | Test Issue 1 | FORCE\Issue\2 | |
| FORCE\Issue\2 | FORCE\Risk Acceptance\1 | 1 | Risk Acceptance | Treatment | Test Risk Acceptance 1 | FORCE\Risk Acceptance\1 | |
| ITRC\Break\3 | Unspecified | 3 | Break | Finding | Test Break 3 | 7890 | ITRC\Break\3 |
| ITRC\Break\3 | ITRC\Remedy\2 | 2 | Remedy | Treatment | Test Remedy 2 | 7890 | ITRC\Remedy\2 |
| FORCE\Issue\3 | Unspecified | 3 | Issue | Finding | Test Issue 3 | 7890 | FORCE\Issue\3 |
| FORCE\Issue\3 | FORCE\Risk Acceptance\2 | 2 | Risk Acceptance | Treatment | Test Risk Acceptance 2 | FORCE\Risk Acceptance\2 | |
I want below output
| TestCase1 | Select BreakID = 1 |
| Type | SourceID | Title |
| Break | 1 | Test Break 1 |
| Remedy | 1 | Test Remedy 1 |
| SEAL DQ | 1 | Test SEAL DQ 1 |
| ACA | 1 | Test ACA 1 |
| Break | 2 | Test Break 2 |
| Application | 1234 | My App Name |
Test case 2
| Type | SourceID | Title |
| Break | 3 | Test Break 3 |
| Remedy | 2 | Test Remedy 2 |
| Issue | 3 | Test Issue 3 |
| Risk Acceptance | 2 | Test Risk Acceptance 2 |
| Application | 7890 | My App Name |
