Jeff George
Well Known Member
Good morning. I'm attempting to build an orchestration (I'm very new to orchestrations) that reads data from a custom table and then performs an action that I've captured with a Form Request. The catch that's causing me difficulties is that the source table is a combination of header and detail and the process uses two different E1 forms (a header and detail).
My question is this: after I've used the SREQ to get the records I wish to work with from the table, how do I work with subsets of that data, e.g. where HEADERVAL1=X, until that value changes? The result should be that it looks at the group of records, creates the header, and then stays in the detail until there are no more records for that set. It works fine if there's only one record for the source data, but that's not reality.
My question is this: after I've used the SREQ to get the records I wish to work with from the table, how do I work with subsets of that data, e.g. where HEADERVAL1=X, until that value changes? The result should be that it looks at the group of records, creates the header, and then stays in the detail until there are no more records for that set. It works fine if there's only one record for the source data, but that's not reality.