Working with ACL views

ACL views let you arrange the way ACL table data is displayed. Views appear in the ACL display area and contain named columns and numbered records. The columns in a view represent fields in the associated table layout – either physical data fields or computed fields.

Views are a flexible tool that allow you to display just the columns of data you want to see in the associated ACL table, and to organize the data in the manner most effective for your analysis. You can create multiple views for the same table, each of them with a different selection and arrangement of fields from the table. For example, if you are interested in only five fields in a table that contains a hundred fields, you can create a view with only the five relevant fields, and put them in the order you find most convenient. You can also use views to format the data for ACL reports.

Figure 1 illustrates views in relation to the other components of an ACL table. For more information about how views relate to ACL tables generally, see The structure of ACL tables.

Figure 1. ACL views

The Default_View

When you open a table for the first time in ACL, a view called “Default_View” is automatically created. The “Default_View” includes all the fields defined in the associated table layout, in the order in which they appear in the layout. You can use the default view without modification, modify it to better suit your needs, modify it and save it as a new view, or create new views that are not based on the default view.

Multiple views allow you to display table data in different ways, to isolate specific fields for ease of analysis, to create data subsets for extracting by view, to include computed fields that perform calculations, and to select and arrange specific fields for inclusion in ACL reports.

The relation between views and table layouts

Although views are associated with an underlying table layout, changes to the view do not change the table layout. For example, if you remove a column from a view the corresponding field is not deleted from the table layout.

Changes to the table layout are not automatically displayed in existing views. For example, if you create a new computed field or define a new physical data field in a table layout, you need to manually add it to any views where it is required. Deleting a field from the table layout does automatically remove the column from any associated views.

Section contents

Related concepts
The structure of ACL tables
Working with table layouts


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback