How to access system tables in UI Builder

[Marc Mouries]

Current situation

By default, System tables are restricted for reporting and in UI Builder. However, in some scenarios, we need to get access to such tables. When building Apps with App Engine Studio we often need access to common tables such as Attachment [sys_attachment] and Email [sys_email] which are not available by default in UI Builder.

Solution 

To expose a system table in AES:
1. Navigate to System Properties > UI Properties (sys_properties.list)
2. Search for the property “glide.ui.permitted_tables”
3. Switch to the Global scope
4. Add the table you need to use at the end of the comma-separated string

 and Voila!

[Maik Skoddow]

I think, you should mention that extending the property glide.ui.permitted_tables not only applies to UI Builder but also to the rest of the platform.

For example, it is possible to create reports on the respective system tables which can lead to a performance decrease in case critical system tables (e.g. sys_audit) are included.

Maik