Report on Delegates

[DanielStyer]

My management has requested to know who has setup delegates. Report? View? :confused:

I do not see the Delegate (sys_user_delegate) table under the Reports and I do not see a Related table > fields option.

[rob_phillips]

The Delegate table is accessible via the report engine. You can also simply report from the UI (User Administration -> Delegates) by filtering, right clicking, etc. You may want to just add some out of box fields to your list such as: created_by, created, etc. and report directly from there.

[CapaJC]

You could create a new module to the sys_user_delegate table and do a "group by" on the list.

Alternately, by default "sys_" tables are excluded from reporting. Can be dangerous. Not in this case, however, so you can designate "sys_user_delegate" as an exception by adding it to the glide.ui.permitted_tables property. Find the property in System Properties --> UI Properties, and the description starts with "By default any system table..." You can add this table to that comma-separated list, and it'll show up in the reporting app.

[CapaJC]

Ah, Rob's right - there's a module already there, and (in /demo at least) I see "Delegate" as already a reportable table, even though it's not listed in that UI property.

[DanielStyer]

I still can not find the Delegate (sys_user_delegate) table. 😮 Am I looking at the wrong place or does something need to be installed?

Step taken:

Reports > View / Run > [New] > Table ..... No "Delegate"

System Definition > Tables & Columns ... it is listed as "Delegate (sys_user_delegate)"