Use relational database views to expand the complexity and functionality of user defined grids in EAM. Define these database views by specifying a unique view name and a SQL statement. Generate these views to make them available for use with Grid Designer. Unlike user defined grids in EAM, views allow you to use outer joins and unions to combine data from two or more tables.
-
Select Administration > Screen Configuration > Views.
-
Click New Record.
-
Specify this information:
View - Specify a unique code value to identify the view database record, and then specify a description of the new record in the adjacent field.
View Name - Specify a unique name which will be used as a reference on user defined grids. All view names must begin with U5.
SQL Statement - Specify the SQL statement query to generate the searchable object or database view.
-
Click Save Record.
-
Click Generate to run the Test SQL process and generate the new database view. If the view is generated successfully, the Active check box is selected, and the view is ready for use with Grid Designer.