Skip to content

Is there a way to search the database for which Lobbies (or Quick Reports, or Events) reference a specific database field, in order to analyze the impact of a planned change to that field?

Answer

Lobby Data Source query definitions are stored in the COMPOSITE_PAGE_DATA_SOURCE_TAB table, but the actual SQL/column content itself is stored as XML inside that table's VALUE CLOB column, rather than as separate readable columns. To find where a specific database field is referenced across every Lobby, a text-based search against that CLOB column's XML content, for example searching for the field name as a substring within the stored XML, is needed, rather than expecting a directly queryable structured column that lists each Lobby's referenced fields individually.

← Browse Platform, Aurena, and customization questions