SQL table/query to show data for "Support Group" for Change Requests
We are looking at creating reports to create an overview of change requests within our section.
As i had extended the class to include "Support Group" within the CR template, the support group doesnt show when our inhouse report developer tries to create queries. He cant locate the tables.
unlike IR and SR where its easy to find the "support Group" tables in the SQL database, we can not locate the tables where the data for support group is written too.
Does anyone know where the tables for Support group in CRs are written too, or any queries that we can use to show support group data for CRs?
Below is the thread which involves the discussion around extending the class. The support group works and everything is fine but we dont know which table it reads to in SQL.
Any help or guidance will be much appreciated.