Cen we possibly create a report using local update sets table?

[John Gospel]

I'm currently working on a report and noticed that some tables—such as sys_update_set—appear to be missing or inaccessible. Has anyone run into this issue when building reports or found a way to include these tables? I’m considering creating a database view as a workaround, but I’d prefer a solution that doesn’t require creating one. Any suggestions?

[Andrew_TND]

Hi @John Gospel 

I’m not logged into an instance to validate, but if it doesn’t work I’ll come back to you with a solution because reporting on update sets sounds interesting.

Try looking at report_view access controls for any restrictions this might solve your problem.

PLEASE MARK AS HELPFUL OR IF ITS RESOLVED THE ISSUE - CORRECT! 

[Bert_c1]

I was able to define a report on the sys_update_set table by creating a Report Source for that table:

Then I defined a report on that Data Source see:

However, I was unable to Save that report, Permission denied 😞

[Chaitanya ILCR]

Hi @John Gospel ,

you have to add sys_update_set table to this property first to be able to report on it

property

glide.ui.permitted_tables

List of system tables (beginning with "sys_", comma separated), that are reportable. By default, system tables are not reportable.

not just this any system table if you want to report against it you have to add the table to this property if it's not already added

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[simaogomes]

Hello @John Gospel  do you have the solution??