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?