Create a WHERE clause - SmartPlant Foundation - IM Update 46 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

You can create a WHERE clause in the Table Properties pane for one or more columns. The WHERE clause is used to extract only those records that meet a specified criterion.

  1. In the Tables pane, select a table.

  2. In the Table Properties pane, click Create WHERE Clause in the Where column for the appropriate table properties.

  3. In the Generate Where Clause dialog box, select the appropriate option to create a WHERE clause.

    • Filter by value - Select this option to retrieve records matching a string.

    • Filter by tables - Select this option to retrieve columns matching the criterion.

  4. Click OK.