Workflow Soluiton

Was wondering if any one can help me take the results from a query ran by a component I created, and split them up into separate vaiables to use in other components. I have a feeling its right under my nose, but I'm missing it.

I have a component that querys in SQL, that returns a ServiceDesk ticket number, and the PO number associated with that ticket. i need to separate the ticket and PO into thier own variables from that collection that is returned. -thanks

I'd suggest using a mapping component (Single Value Mapping)... though I'll try and make this work later

I added the add data element component, specified that it is the data type returned by the integration component i created, but I can't specify a variable to be used for the value.

I feel like I may be missing your point though.

Apologies for that previous post, was trying to get it working and then got derailed.

I got this working using a Build Text From Elements components. You can add a Single Process variable and specify [abcResult[first].Column1] or [abcResult[first].Column2]. See the attached project (renamed from .package to .zip).

My integration library uses the simple SQL "SELECT 'a' as Column1, 'b' as Column2"

Let me know if you don't follow.

Attachment(s)

DecisionProject1.zip   1.01 MB 1 version

Unzipped the file but i can't open the project in workflow.

The previous zip was meant to be renamed as a .package, but anyway...

The configuration of the Build Text from Elements component should look like this (assuming an query/script integration library that matches the above - the output of the integration library is "abcResult", in this case)

Reecardo,

You are the man. Exactly what I needed. Thanks a million.