Lookup SQL

Users with Read privilege for the Security Group ADMIN_LOOKUP_SQL can use the Lookup SQL page to search for system components where a particular SQL fragment is used.

 

 Steps to Search by SQL Code Fragment

Step

Instruction

Screenshot Help/Example

Step

Instruction

Screenshot Help/Example

1

Access the Lookup SQL page by accessing Dev Center > Application Process Management > Lookup SQL.

 

 

2

Click the filter name for the page and then click Edit for the filter.

 

3

Complete the following fields:

Component Name – To choose a specific component, select from the dropdown list.
SQL Fragment - Enter the SQL fragment to search for.

 

5

Click OK to display results in the grid.