Reporting on Service Item Variables

[mehling]

Hello,

I am seeking assistance with reporting on variables from a custom task in ServiceNow. My current approach involves using a Database View, but this method results in an excessive number of records, causing the system to crash and time out without displaying useful information.

Could anyone advise on how to apply filters to a Database View before it runs, or suggest a more effective way to report on question responses within a service task?

Thank you.

[josephmorsb]

It looks to me your where clause is off a bit.  Your table alias is "answer", but your where clause is using "answer_table_sys_id" when I think it should just be "answer_sys_id"

It's possible the join is failing and you're getting all the records from u_it_operations_task, plus all the records from question_answer.

[mehling]

Hey josephmorsb, I have confirmed this is the correct column name.