Need help to create report on sys_trigger table

[Snow User4]

Unable to create a report on sys_trigger table as that table is not found in reports tables list.

Please suggest to create a report on this table

@Ankur Bawiskar  @Sandeep Rajput  please suggest

[Sagar Pagar]

Hi @Snow User4,

You have to add sys_trigger table in system property: glide.ui.permitted_tables. It will allow to create report on sys_trigger table.

For more info: Reporting on system tables 

Thanks,
Sagar Pagar

[Sandeep Rajput]

The tables in this list is governed by glide.ui.permitted_tables System Property.

Table sys_trigger can be added in this list by making following changes.

Search the property glide.ui.permitted_tables in system property.

Add sys_trigger table in the value field and saved it.

This change will make your table sys_trigger available for reporting.

Hope this helps.

[Tony Chatfield1]

Hi, running reports against core system tables may result in degraded performance
and as sys_trigger records exist only until they are processed, with most processed in (near) real time, there should not be a lot to report on.
Can you clarify your business requirement\use case?

[Ankur Bawiskar]

@Snow User4 

Reporting on that table is not recommended.

What's your requirement?