Adding and removing columns from data views

Updated in 2024

When you open any record in Alloy Navigator Express, you will see a set of properties, which are fields with individual values. Some fields, like Status or Category, are common across all records, while others are specific to certain classes. For instance, tickets have fields like Requester, Assignee, and Due Date, whereas computers have fields such as Computer Name, Serial Number, and Owner. In data views, which are lists of records, these fields appear as columns with corresponding values for each record. To avoid clutter, data views initially display only a subset of available record fields. You can customize your data views based on your needs by removing some columns, adding new ones, and rearranging their display order. Read this article to learn how to show or hide record fields in your data views, i.e., how to add or remove columns.

TIP: When Alloy Navigator Express loads data views, it retrieves from the database on the SQL Server only the visible fields' values. Therefore, hiding unnecessary fields from the view can help avoid long waiting and reduce network traffic, especially if your network connection is slow and the number of records to retrieve is large. Other means to reduce network traffic and speed up loading data are applying filters (see Filter tab) and limiting the number of records to retrieve (see Change the limit of records to retrieve).

To add columns to a data view:

1. Click the gear button in the upper-right corner above the data grid to open the Customize View pane, then click the Columns tab.

2. To add a column to the data view, click + More and select the corresponding field from the drop-down list. To add more columns, repeat this action for each field you want to show.

   TIP: New columns are added to the end of the list, appearing on the right side of the data grid. Now you may want to drag them to your desired location. For details, see Changing the order of columns.

3. Apply your changes or save them. For details, see Saving and applying changes.

To remove columns:

1. Click the gear button in the upper-right corner above the data grid to open the Customize View pane, then click the Columns tab.

2. Locate the column to remove, click on the three vertical dots icon associated with it, and select Remove from the menu. To remove several columns, repeat this action for each field you want to hide.

   

3. Apply your changes or save them. For details, see Saving and applying changes.

Related Information:

Arranging grid columns and rows

Customizing grids