|Query panel toolbar
||Used to manage queries. Located at the top of the
Delete Query, Rename Query and Promote to Shared Queries
| Delete Query
||Removes the selected query.
||Renames the selected query.
|Promote to Shared Queries
||Adds the selected query to the
Shared Queries folder where it can be
viewed by all project members.
queries can not be deleted, renamed or promoted.
||Lists your user defined queries. Selecting them
updates the query panel. Queries in this folder can be promoted to the
Shared Queries folder.
||Lists queries shared among the project. Selecting
them updates the query panel. Queries in this folder are intended to be viewed
by all project participants.
provides predefined queries such as Equipment List and Instrument
List as well as an All Data query. Selecting them updates the
query panel. The
Query Builder can then be used to filter the
||Located above the query table, the Query Builder is
used to create queries from the loaded data. Clicking on the Query Builder
expand its settings.
||Sets the object class to search for in the query.
||When on, you can filter the results of the query with
Where Cause settings. Use the three fields
to set the where clauses. Clicking the plus sign (+)
adds another where clause statement to the query. The trash can icon removes
And/Or operators are used to connect the
where clause statements. Where clauses are resolved chronologically.
|Query Builder toolbar
Save Query, Save Query As, Run Query
||Saves the where clause. A Save dialog opens
where you can enter a name for the query.
||Saves the where clause as another query. A
Save As dialog opens where you can enter a name for the query.
||Press to apply query settings to the data.
||When on, the Query Builder controls are removed from
the interface, and a text field is provided for you to enter query statements
In this example, text entered into the field:
select DISTINCT pn.CodeValue as
Pipeline_Tag, pn.PLANT_AREA, pn.DESIGN_SIZE, ps.FROM_COMPONENT, ps.TO_COMPONENT
from ProcessFunctional.PIPING_NETWORK_SYSTEM pn INNER JOIN
ProcessFunctional.PIPING_NETWORK_SEGMENT ps on pn.EcInstanceID=ps.Parent.id
WHERE (FROM_COMPONENT <> '' OR TO_COMPONENT <> '')
Yields results which are displayed in the Query Results table.
The table can be exported to Excel by clicking the "Export" icon in the toolbar
(under "Records count").
|Query results toolbar
||Used to manipulate the search results.
Edit, Import from Excel, Export to Excel, Column Options
||The first tool in the results toolbar above the
results table, Edit (pencil). Click to enable editing in the results table.
When editing is enabled, the tool bar above the results table changes, adding
|Import from Excel
||The next tool in the results toolbar, Import
from Excel (X with clockwise arrow). Click to import query data from an Excel
|Export to Excel
||The next tool in the results toolbar, Export
to Excel (X with counter clockwise arrow). Click to export the query to an
||The next tool in the results toolbar, Column
Options (3 vertical bars). Clicking opens the Column Options pop up dialog.
- Drag to
rearrange - Clicking on a column entry changes the pointer to a
move style allowing you to click and drack the columns to change their
arrangement on the results table.
- Hide column -
X button next to the column name
to turn off the display of the column in the results table.
Only/Editable - Click the
"eye" icon to make the content displayed
in the column read only, or click the
"pencil" icon to make the content
- Save - Click to
save the column options for the current query.
- Default - Click
to save the column options as the default for all queries.
- Cancel - Click
to discard the column option changes and close the dialog.