Archibus Smart Client

Access Any Database Table by Creating a New Grid View

You can use the Views tab on the Explorer pane to create new grid views by selecting a table to add to the view, the fields to include in the view, sort order, and so on. After customizing the view, you can save the view to your Favorites list.

You can create ad hoc views for reviewing the data in any table or the schema underlying the table. Use this feature to access any table in the database; this is especially hand for accessing tables for which no corresponding task exists on the Smart Client Navigator.

Archibus Cloud Users

If you are running Smart Client as part of an Archibus Cloud deployment, the Explorer's Views tab is hidden based on security groups. This enables administrators at your site to explicitly provide control as to who has access to the Views tab.

Cloud partner administrators (such as user AFM-BP) and cloud administrators (such as user AFM-CLI) can access the View tab because they are assigned to roles that are assigned the "%" security group.

To activate the View tab for specific security groups:

1. Run the System Administration / Archibus System Administration / Archibus Administrator - Application Configuration / Configure Application Parameters task.
2. Choose the AbSystemAdministration application.
   
3. Set EnableSCViewsTab to the desired security groups.
4. Users who are members of roles assigned to these security groups will now have access to the Views tab.

To create a new grid view:

1. From the Explorer panel, select the Views tab. The system displays a list of all tables in the database. You can filter this list by completing the filter tab in the top row, as shown below. For information on filtering, see Searching for Records Using the Filter Row.
   
   
2. Select the table that you want to examine by clicking the row header for the table in the list.

3. Click Add, or, double-click the table.

   The grid displays the selected table with a default set of fields. See Overwriting Default Grid Views for information on how the default fields are determined.

4. Your new grid view (named according to the selected table) is added to the top panel of the Views tab for future access. See Loading Views that you Recently Created.
5. If needed, use the following commands to customize how the view presents records from this table.

   To...	... Run this command
   Add or remove fields	View / Fields (on the Ribbon) See Selecting the Fields to Display.
   Set filters to restrict the records that display	Filter / Filter (on the Ribbon) See Creating Complex Filters. Filter / by Row (on the Ribbon) See Searching for Records Using the Filter Row Using the Filter Icon Options to Restrict the View
   Sort the rows	Sort (Column header action) See Sorting Columns

6. Optionally, add a second table to the view by double-clicking a table in the Explorer pane's list. The table list is restricted to show only those tables that can be related to the first table selected. For example, if you are examining the Divisions table, you can add the Departments table so that your view presents all departments assigned to each division. Use the Back button to return to the list of all tables.

   The list indicates whether the table can be used in the standard role or as a child table in this view.

   • Standard Table: If a table in the standard role is added, the command makes its key field and description field visible. 

   • Child Table: If a child or drill-down table is added, the command adds the table as a child to the first table. Click the plus sign to see the child records. See Parent-Child Grid Views.

7. If needed, customize the fields for the second table using the commands in the above table.
8. Optionally, select a third table by double-clicking the table in the list. If a child table was selected as the second table, the list of tables includes only tables that can be related to that child table.
9. If needed, customize the fields for the third table using the commands in the above table.
10. If you want to save the view, see Saving Views.
11. If you want to start a new view and clear the Details pane, choose Reset to clear the current view. You can always return to this view by selecting it from the top of the Views panel. See Loading Views that you Recently Created. You can now create a new view by following the above procedure.

Note: If you are creating a view to import or export its data, be aware that data transfer exports only the fields in the main table. See Data Transfer Overview.

See Also

Adding Default Smart Client Views