Create a new external data filter query - Intergraph Smart Construction - 2019 (7.0) - Help - Hexagon PPM

After creating the external data filter connection object, you need to specify the query to run against the data provider. The query must be a standard SQL select type query that returns data for the objects that meet the query criteria, such as Tag Number, Line Number, or spool. Those fields can be mapped to an existing property of the object in the SmartPlant schema.

1. Log on to SmartPlant Foundation Desktop Client as an administrator.

2. Click Smart Construction > New > Administration > External Data Filter Query to open the External Data Filter Query form.

3. On the External Data Filter Query form, type a name for the data filter query in the Name box.

4. Type a description for the data filter query in the Description box (optional).

5. Type a query string in the Query string box.

   The query string must be a standard SQL select statement that returns the objects that you want to select in the 3D model or 2D drawing, as seen in the following example:

   SELECT <FieldName> FROM <Table> WHERE <Condition = 'Value'> ORDER BY <FieldName>.

   For example, a query string for a spool external filter could be SELECT Spool_No FROM [SummaryReport$].

6. Click Apply or Finish to save the New External Data Filter Query form.