Relations View

You can view relationships associated with an entity in a tabular format.

Overview

Besides providing the layout in a tabular format, this view allows you to sort, search, filter and even show/hide columns that you want to focus on. Let us explore this view in detail.

Note: To see the Relations view in a table or list format, you can set the Mode option for Facet Display in the Relations View Properties in UI Modeler. For more details, see UI Modeler Properties Configuration.

The tabular view lists multiple entities or relationships as individual row items. Multiple columns display the relationship attributes.

In the sample images below, only four attributes or columns have been chosen to be displayed. You can change the layout by selecting the attributes or columns that you want to display. For more information, see the Selecting the Attributes or Columns to Show section. In addition, you can set the number of rows that you want to view by changing the Rows per page value at the bottom of the tabular view. You can set it to either 10, 15, 25, 50, or 100 rows per page. Use the left and right arrows to go to the previous and next pages.

Sorting the Relationships

You can sort the relations in the ascending or descending order of any attribute or column. The image shown below shows that the first column (Entity label) is sorted upon. When you hover over the column name, you can use the arrow for sorting.

The upward arrow indicates the Ascending order of sorting, whereas, the downward arrow indicates Descending order.

Searching the Relationships

You can use the Search icon () at the top of the view to search for the relationships that you want to focus on. Enter the term that you want to search upon and click Enter. The results are displayed in the view. The number of entities that match the search term are displayed next to the search term. In the example below, 4 entities matched the search for the active records.

To close the Search box, click Close and the view is restored back to normal (pre-search) view.

Applying Filter Options on Attributes

You can use the filter feature () to view the details of only the required relations. When you click the Filter icon, the filter icon changes () and the filter drop-down becomes Active on all the attributes or columns as shown below.

Now, you can select any attribute or column and set the filter option on that attribute. For example, see the Direction label attribute with an active filter drop-down in the image shown below.

You can click the arrow next to the equals operator to see the list of applicable operators based on the attribute or column you are filtering upon.

In the following example, the filter option is being set for Direction label attributes that start with Inactive.

The filter condition is applied when you click anywhere outside of the filter condition setup dialog box. The following image shows the filter condition and the expected results in the view.

To remove the filter condition, you can either click Close on the filter condition or click the active Filter icon. In both the cases, the view is restored back to normal (pre-filter) view.

Selecting the Attributes or Columns to Show

You can select the attributes or columns that you want to view in the tabular view by clicking the Show/Hide Columns icon ().

The Show/hide columns multi-select list appears. You can either scroll through the list of available columns or search for the column that you want to display.

Click APPLY to save your selection. The selected columns are added to the right of the existing last column on the right.