Add Column and rows to dataset from tag

I have a Flex Repeater populating based on a query binding on the instances property with return format json as follows:

select job_number as JobNumber
from jobs

This correctly populates the Flex Repeater component with every Job on my database, however I have a State value for each Job that is only located on a tag. I am wanting to add that State column to the returned query data. I assume the best way to accomplish this is to change my return format to dataset and loop through each of the [default]Job/Job 1/State…[default]Job/Job 10/State tags and then add each state to the corresponding Jobs row. My current dataset with only the query looks like this:

JobNumber
1
2
3
4
5
6
7
8
9
10

And I need to add the State to the dataset to look something like this:

JobNumber State
1 1
2 0
3 0
4 0
5 1
6 0
7 0
8 0
9 0
10 0

How would I go about parsing through the tags in order to add the State column values to the dataset?

The answer to this question, (modify the value in a script transform) has been given in this thread:

Double posting is against forum policy.

1 Like