The CreatorCon Call for Content is officially open! Get started here.

Reports on Task_SLA table not retrieving custom fields of Incident

sarahmustakim
Kilo Contributor

Hi,

I've built a report on Task SLA table. However when I'm trying to dot walk to the incident table from there I'm not able to see any of my custom fields in Incident form.

Please assist!

Reports.JPG

Thanks,

Sarah

1 ACCEPTED SOLUTION

You can try reporting on incident_sla table. It is a table join of incident and task sla.


View solution in original post

9 REPLIES 9

Hi Wayne,



I don't see any Incident Field under 'Task -> Task Fields',





Thanks,


Sarah


Hi Sarah,


I don't think its going to work in the Stacked by field. It will work in the Group by field, if you press the + beside the field.


It all depends on what type of a report you want. Is this the exact format of the report? Is the requirement to show the data in a particular way?


You can get to to the incident fields in a report, just not in 'stack by', because, that will only stack for the table you are reporting on.



Please mark this so if you find it helpful


Rodrigo Higa
Kilo Guru

Hi Sarah,



You can enable the system property "glide.ui.list.allow_extended_fields" in the table sys_properties.



This will show you the incident algo, when you select to 'Show related fields'.



find_real_file.png


Regards,


Rodrigo Higa


Where do you go to make this update?  "You can enable the system property "glide.ui.list.allow_extended_fields" in the table sys_properties."?

 

I'm looking at the sys_properties table in our QA instance, and don't see where I can enable system properties.