FAQ table and Service ID

[QEHNick]

I'm running a report on FAQs and I'm keen to view the service they are allocated to (as you know, it's very hard to track them down).

However, the report refuses to produce the value in the Service ID field; niether "h_itsm_faqs.h_service_name" nor "h_itsm_faqs_h_service_id" will produce any value.

Indeed, even attempting a "Data Preview" will have it's wheels spinning. Outputting the report to a file simply does not include the Services data, everything else is there though.

is this a known issue?

[Victor]

7 minutes ago, QEHNick said:

is this a known issue?

@QEHNick might be that the query behind the report takes longer than 30 sec to execute. All queries are set to timeout after this time and if a query times out then it will have no results which means the report will also have no results...

[QEHNick]

That sounds a reasonable theory, however, in practice the report is generated in a second or two.

[Victor]

@QEHNick hmm..2 seconds.. does the generated report have have data in it?

[QEHNick]

Yes, all but the missing Service ID fields.

[QEHNick]

Here's our definition file if you want to try it out.

 

faq-views.report.txt