Query Preview Tab - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Help
Smart Instrumentation Version
13.1

The Query Preview tab is where a preview of the query is displayed.

QB Preview Data

Select QB Generate Preview to generate the preview. Selecting Preview, after making changes in the attributes order, resets the columns in the preview to the saved layout in the Query Attributes pane.

Selecting on Filter QB Filter in a column header, opens a Filter dialog where you can create a filter to be applied to the selected column. Filters can be applied to multiple columns. Only the first 1000 items are displayed in the Filter dialog.

Columns can be sorted by selecting on their name (shift + column names for multiple column sort). First select ascending order, second select descending order, a third select cancels the sort operation. The sorting is not saved to the query on closing.

Search

Use the Search field to search all the fields of the displayed page, for example to check query contains the data you want to appear in the EDE. As you type in the Search field, the software highlights in yellow all the fields matching the search string and filters out those rows that do not match the search criteria. Also from the third character of the search criteria, the software displays the first five items that meet the search criteria. Selecting on one of these results, filters the preview grid to display just those items that match your selection.

Displaying Rows

Displays the first and last row number of the displayed page in relation to their position, within all the pages of the retrieved data and the total number of rows retrieved.For example, 601 to 700 of 22545 rows.

  • The Query Preview displays a maximum of 100 rows per page.

  • After applying a filter to your query the number of rows is still displayed even if because of the filter it appears that there is only one page in your query. For example, before filtration 601 to 700 of 22545 rows. After filtration 100 of 22545 rows.

  • When your query retrieves less than one page, then just the number of rows on the page are displayed.

Page Controls

Use these controls to find a page within the retrieved data. Use the Forward and Back arrows to move one page at a time. Use the double arrows to move to the first or last page of the retrieved data. Use the box provided to type a page number to find a specific page.