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?