The Report Designer by default enables Database Views created at the Application, Case Type, User and Contact levels. If an application needs additional tables/views/stored procedures specific to the application, then they must be configured in the database, in the EC_APPLICATION_SETTINGS table with the key “ReportDesignerDbObjects.”
NOTE: Only one key is allowed per application.
If multiple tables/views/stored procedures must be enabled, combine all the names with commas separating the items, and use the informal names of the objects without the database name or the schema name as prefixes.
NOTE: The SQL query to add other non RV_ tables to the Query Builder:
INSERT INTO EC_APPLICATION_SETTINGS (APPLICATION_TYPE_ID, APP_KEY, APP_VALUE) VALUES (1, ‘name of the table you want to add’, ‘any other table you want to add- list separated by commas’)