Getting display information from the question_answer table with reference fields

[KB15]

What's the best way to query for values that are reference fields in the question_answer table?

The reference field returns the sys_id value. I need to get the display value of that sys_id instead to output into a task so it's readable.

[Jace Benson]

So in the past i've added a column to that table, and then added a business rule to figure out the questions's reference table, then write that to the table.  Reference variables, Lookup Select variables, and List collector variables all use different fields, but you should be able to run with this and make it work.  Then the display will match the value at least when it's submitted.  If you try to make it a reference to the table, that would be more complicated.

[KB15]

I decided to create an overly simplistic query to determine what two of the sys_id values would be. It's not pretty but it works. I appreciate the idea but I was only looking to find two values instead of all reference values.

The other option, which I'll be doing in the future iteration, would be to run a script to pull in all values with the reference value to a scratchpad and search against it to verify the data information within the workflow. Scripting it would be the next challenge.