angie_moore
Member
Hello All.
I'm new to all of this and working on a project to send a message with sales order shipment information. The problem is that I want to show details for multiple lines from the sales order in a single message. I thought I could create an orchestration and run it on a nightly schedule. The first step would be a data request to bring back all (distinct) orders that shipped today in a dataset. Then connect to a child orchestration which loops thru that list and finds all the lines per order and sends the message. We are running 9.2.4.0 tools.
The first challenge is getting the list of distinct orders. Is it possible to return a list of distinct values from a Data Request?
The second challenge is creating the body of the message. Is it possible to concatenate values in a dataset? Could this be achieved with a custom groovy script.
Thanks for any help!
Angie
I'm new to all of this and working on a project to send a message with sales order shipment information. The problem is that I want to show details for multiple lines from the sales order in a single message. I thought I could create an orchestration and run it on a nightly schedule. The first step would be a data request to bring back all (distinct) orders that shipped today in a dataset. Then connect to a child orchestration which loops thru that list and finds all the lines per order and sends the message. We are running 9.2.4.0 tools.
The first challenge is getting the list of distinct orders. Is it possible to return a list of distinct values from a Data Request?
The second challenge is creating the body of the message. Is it possible to concatenate values in a dataset? Could this be achieved with a custom groovy script.
Thanks for any help!
Angie