Filter or sort the results - HxGN SDx - Update 63 - Help

HxGN SDx Help

Language
English
Product
HxGN SDx
Search by Category
Help
SmartPlant Foundation / SDx Version
10
  • At the top of the required column, select Column Settings , and then select one of the following:

    Select this

    To do this

    Sort Ascending

    Sort the results in ascending order.

    Sort Descending

    Sort the results in descending order.

    Columns

    Select the columns displayed in the table.

    Filter

    Filter the table using standard parameters, such as Contains.

How do you use the Filter settings?

You can select different Filter options in each column to refine the results to a specific set of objects. Filtered columns display a filter flag .

  • Select the Filter option, and enter the required value to filter the column results by that value.

The following table shows the main filter options:

Filter option

Description

Is equal to

Use the Is equal to operator to filter for objects that equal a value in the column item.

For example, you filter the State column to see only objects where State is set to Current.

Contains

Use the Contains operator to filter for objects that contain a specific value in the column item.

For example, you filter the Title column for objects that contain the value Gas.

Starts with

Use the Starts with operator to filter for objects that start with a value found in the column item.

For example, you filter the Title column so only objects where the title starts with Gas.

Ends with

Use the Ends with operator to filter for objects that end with a value in the column item.

For example, you filter the Title column for objects where the title ends with Sheet.

Is empty

Use the Is empty operator to filter for objects that have an empty value in the column item.

For example, you filter the Title column for objects that have an empty value set in the title.

The Is not empty operator filters for objects that don't have an empty value in the column item.

Is null

Use the Is null operator to filter for objects that have a NULL value in the column item.

For example, you filter the Criticality Rating column for objects that have a NULL value in the column.

The Is not null operator filters for objects that don't have a NULL value in the column item.

Has no value

Use the Has no value operator to filter for objects that have either an empty value or a NULL value in the column item.

For example, you filter the Criticality Rating column for objects that either have no value set or have a NULL value in the column.

The Has value operator filters for objects that don't have an empty value or a NULL value in the column item.

Is greater than

Use the Is greater than operator to filter for objects that have a value greater than the value provided.

For example, you filter the Version column for objects that have a value greater than 1 set as their version.

Is less than

Use the Is less than operator to filter for objects that have a value less than the value provided.

For example, you filter the Version column for objects that have a value less than 3 set as their version.

  • The list of filter options depends on the configuration of the column set. Not every filter is available for each column item in the list.

  • Depending on the column item selected, some filter options can show a list of existing values in the Select Value list.

  • You can use the And or Or syntax to narrow results to include a range of values, especially when there are multiple values in the same column item. For example, by setting Starts with to 100 and Ends with 150, only objects between those values are displayed.

  • You can combine multiple filters to display a specific set of data. For example, using the Contains and Ends with filters, you can filter the Name column using Contains 1011, an AND, and Ends with HSE. Only objects with names that contain 1011 and end with HSE are displayed.

  • You can use wildcards to further target results. For example, if you use *(all) with 01 to filter for objects, (01*), you will get every object with 01, such as 01, 01A, 01B, 01C, and so on