I assume you are trying to populate an array process variable in BizFlow? You can perform your SQL query and map the database response to the array structure using a set of Copy and/or Move Actions in your rules. You will need to use the Invoke Service action in your rules and use the Service Call Helper to select the SaveWICDetails Pattern and Controller Node.
Once you have done this your Invoke Service Action should have a Service entry similar to mvc-Arrays-SaveWICDetails-Controller and an Action entry of Invoke. Where Arrays refers to the project name is this context. You can use / and / for the from location and to location XPaths. This will invoke the BizFlow Web Service API to update the Process Variables fragment.
Please remember to define your array as a 2d array to represent a 1d version, e.g. (1,n) or (n,1). WebMaker does not support 1d BizFlow array formats.
There is additional material on the forum, which you can locate by using the Array search string. I hope this helps.
RE: How I can fill a one-dimensional array from a SQL query
I assume you are trying to populate an array process variable in BizFlow? You can perform your SQL query and map the database response to the array structure using a set of Copy and/or Move Actions in your rules. You will need to use the Invoke Service action in your rules and use the Service Call Helper to select the SaveWICDetails Pattern and Controller Node.
Once you have done this your Invoke Service Action should have a Service entry similar to mvc-Arrays-SaveWICDetails-Controller and an Action entry of Invoke. Where Arrays refers to the project name is this context. You can use / and / for the from location and to location XPaths. This will invoke the BizFlow Web Service API to update the Process Variables fragment.
Please remember to define your array as a 2d array to represent a 1d version, e.g. (1,n) or (n,1). WebMaker does not support 1d BizFlow array formats.
There is additional material on the forum, which you can locate by using the Array search string. I hope this helps.
Kind Regards
Abdul
RE: How I can fill a one-dimensional array from a SQL query
RE: How I can fill a one-dimensional array from a SQL query