UI Builder - how to get the number of attachments related to a given record

[Marcin20]

Hi Experts.

I am trying to create a Data resource - Aggregation Query to get the number of attachments related to a given record.

However, I cannot select the sys_attachment table in the 'Table' field.

Please could you help me how to make this table selectable?

Alternatively, could I use another type of Data resource to execute a script on the server side and get the number of attachments as a result of this script?

Best Regards,

Marcin

[Swapna Abburi]

Hi @Marcin20 

System tables are usually not available reporting. If it is a must requirement, you can make them available for reporting by updating the system property "glide.ui.permitted_tables".

Please note that as attachment table is huge, it may cause performance issues.

[Marcin20]

Hi,

Thank you very much.

 I will try another approach then - use the script in the data resource.

Best Regards,

Marcin