I am working on a report someone else created on the incident table which is using a group by clause on a variable/question from the record producer. A record producer is being used to create the incidents and populate certain fields, but a number of values are used only in the record producer questions and multiple values are concatenated in the description. On the screenshot below the group by is using the variable “This request for claims is being submitted on behalf of:” Which is a choice list variable/question in the record producer, but the report definition is against the incident table and I cannot see record producer questions or variables from the incident table. This is in the Paris release.
The original report creator is unavailable and I can’t figure out how they could use questions as a group by options for incident records. The report source is the incident table and not a view tying to the questions. When we go to the report designer group by option for the incident table, “variables” and “questions” are not choices in the column list. I can see the “variables” column in the group by option and modify the choices when I use the catalog task table, but not incident. If I look at the incident record a related list is displayed containing the variables associated with incidents that are created by the record producer.
Here is the report definition record:
It also includes the following column values:
- Service Catalog Group By Variable Id=26831f361b53d05cb8c0ebde6e4bcb77
- Service Catalog Group By Item Id=93ce87b21b13d05cb8c0ebde6e4bcb9d
How can I report on Incidents created from a record producer and use the record producer questions as a group by option?
Thank you for any assistance!
