Closed
How to retrieve records from IH Summary for multiple SubjectIDs
Use Case:I have a use case to retrieve IH summary for multiple SubjectIDs within the same strategy(Refer the attached screenshot-IHSummary.png.) We need to retrieve IH for multiple subjectID as we need to fetch the count based on another field in IH that has one to many relationship with the SubjectID. Arriving at this count is the primary purpose of this strategy.
IH Table
| SubjectID | Field2 | Offer |
| 1001 | A | X |
| 1002 | A | X |
| 1003 | A | Y |
| 1004 | B | X |
| 1005 | C | X |
Expected result
| Count of A having X offers | 2 |
| Count of B having X offers | 1 |
| Count of C having X offers | 1 |
Query: Is it possible to retrieve IH summary for multiple subjectIDs in a strategy. If so, how to achieve it?
Note: When referring an IH summary component in a strategy for single SubjectID and SubjectType I am able to retrieve IH results.