How to add sys_attachment table available for reporting?

Community Alums
Not applicable

‎01-23-2017 10:17 AM

I need to report on 'sys_attachment' table. But this attachment table is not appearing on the Reports table field. How can I include 'sys_attachment' table? any settings?

find_real_file.png

Labels:
Preview file
31 KB
0 Helpfuls
  • 2,286 Views
5 REPLIES 5

Sashi K1
Kilo Guru

‎01-23-2017 10:41 AM

Hi


System table are not subject to reporting by default. You can still make them available for reporting by changing the property glide.ui.permitted_tables.


You can navigate to System --> UI Properties --> scroll down you can see to modify



However system tables are huge in size. They cause performance problems. Please note this point.




Community Alums
Not applicable
In response to Sashi K1

‎01-23-2017 11:32 AM

Thank you Sashi. It worked.


0 Helpfuls

Sashi K1
Kilo Guru
In response to Community Alums

‎01-23-2017 01:16 PM

If my answer solved your immediate question, please mark it as answered 🙂


0 Helpfuls

Community Alums
Not applicable
In response to Sashi K1

‎01-23-2017 03:09 PM

Sure. I always do that. But, now I am not able to locate the Correct Answer button. I just marked one today morning. Looks like it disappeared now.


Do you know how to enable this?


0 Helpfuls