For sc_req_item and sc_task, I know that I can use variables from catalogue requests in filters and report columns. The variables field is on the task table, and therefore is present on all tables that extend task. For task table records, such as incident, the variables field is populated from the record producer variables.
Is it possible to filter on the variables field on task tables other than sc_req_item and sc_task, and what needs to be done to enable filtering on variables?
Sorry, but I tried at my end and did not see any field which can help to filter with INC or change. Seems it is not possible here or log a case to HI support to get some inputs.
************************************************************************************************************* If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards Dr. Atul G. - Learn N Grow Together ServiceNow Techno - Functional Trainer LinkedIn: https://www.linkedin.com/in/dratulgrover YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
Thanks for the response. However, creating a database view is no longer necessary in order to report on variables in sc_req_item, as a I explained in my original post.
Although a database view could provide the solution for other task table, I was hoping there would be a simpler solution such as setting a table attribute.
