OIC Call to BIP report with multiple values in parameter
Summary:
OIC Call to BIP report with multiple values in parameter
Content (please ensure you mask any confidential information):
On the OIC SOAP Adapter for ExternalReportWSSService (to call BIP report), in the parameterNameValues, how can I pass more than 1 value in the same parameter with one Report call from OIC? I want to pass a parameter to BIP report that is used in the IN operator on a WHERE clause in BIP report
(i.e. SELECT * FROM ABC WHERE invoiceID IN (ATTRIBUTE1) --Where ATTRIBUTE 1 contains multiple comma-separated values, passed by OIC integration call
The Target node 'item' is a repeating element, so it seems that it would be able to handle multiple values passed to it, but I only want the BIP report to be triggered once from OIC integration.
Tagged:
0