I am trying to design a synchronous interface. I need a structure which is equivalent to the following query
"select ORDER_ID, STAT from HDR where ORDER_ID in ('123','456')"
I tried with the below structure.
<?xml version="1.0" encoding="UTF-8"?>
<ns0:MT_Output xmlns:ns0="Namespace"><StatementName1><CV action="SQL_QUERY"><access>select ORDER_ID, STAT from HDR where ORDER_ID in ('$ORDER_ID$')</access><Key><ORDER_ID>123</ORDER_ID><ORDER_ID>456</ORDER_ID></Key></CV></StatementName1></ns0:MT_Output>
But we are getting reponse for the first value only. Please tell me how to change this structure accordingly, so that i need to get response for all the values of the field ORDER_ID