I have a survey and those filling out the survey are asked if a condition has passed or failed. There are close to 50 questions like this. When a condition has failed it is expected that the person filling out the survey will include details on the failure.
The table that collects this information has schema similar to this: Condition1, Condition1 Comments, Condition2, Condition2 Comments, Condition3, Condition3 Comments; ad nauseam.
I have created a TestFilter to test for the different conditions. Now for each specific failure I have a corresponding outport. The records that go through these outports will be turned into Cityworks Work Orders. Thankfully, they are all considered the same work order (a generic one).
I'm a bit puzzled with how to manage the comments. How can I grab the corresponding comments for a failure? It would be good to also have the ability to report more than one failure and grab all of the comments.
I hope I've provided enough detail. I appreciate any help.
Cheers,
A-U