HyperView User's Guide

Query Panel

Query Panel

Previous topic Next topic Expand/collapse all hidden text  

Query Panel

Previous topic Next topic JavaScript is required for expanding text JavaScript is required for the print function  

The Query panel allows you to view and export properties and other information for nodes, elements, components, and systems contained in the active model.

To access the Query panel, click on the Query button resultsQuery-24 on the Results toolbar, or select Query from the Results menu.

query_control_panel

Query panel

To query entities in the active model: define a selection set using the input collector or by picking entities directly on the model (the selected entities are highlighted in the graphics area), check categories in the list, and click the Apply button.  The requested information is displayed in a table .  The cells within the table are disabled and cannot be changed.  However, you can copy and paste highlighted cells into other programs using CTRL + C and CTRL + V for copy and paste, respectively.

The input collector and the option list allow you to define the selection set to be queried.

Input Collector

The input collector allows you to define a selection set for which you would like to display information.

Option List

Below the input collector and on the left-most side of the panel is the option list.  You can activate the check box next to the information you would like displayed in the table.

query_options_list1a

The options available in the option list change, depending on the current input collector.  They include:

Model Identifier

Displays the source of the data in the table.  For instance, p1w1m1 means that the data comes from model 1, which is located on page 1 in window 1.  This option is for all entities.

Nodes

Node ID, Node Pool, Reference System, Analysis System, Node Coordinates, Node Coordinates (Tracked), Component ID, Component Pool, Component Name, Component Color, Original Data, Load Case, and Simulation Step.

Note - The Node Coordinates (Tracked) query field will output the node coordinates relative to the tracking system.

The Contour (value) and Contour Resolved-In System options are available if a contour has been applied to nodes or averaged to nodes.
The Vector (value) and Vector Resolved-In System options are available if a vector plot has been generated at nodes.
The Tensor (value) and Tensor Resolved-In System options are available if a tensor has been applied to nodes.

Note - For MinLayer/MaxLayer/ExtremeLayer, the query will return the layer name and the value.

Elements

Element ID, Element Pool, Element Config, Element Connectivity, Element Normal, Element Centroid, Component ID, Component Pool, Component name, Component Color, Load Case, and Simulation Step.

The Contour (value) and Contour Resolved-In System options are available if a contour has been applied to elements for centroid or corner results.

The Tensor (value) and Tensor Resolved-In System options are available if a tensor plot has been generated at the element centroid.

Note - For MinLayer/MaxLayer/ExtremeLayer, the query will return the layer name and the value.

Components

Component ID, Component Pool, Component name, Component Color, Load Case, and Simulation Step.

Contour Min/MaxMin/Max IDMax ID's Pool NameMin ID's Pool Name, and Contour Resolved-In System options are available if a contour has been applied.

Vector/Tensor Min/MaxMin/Max ID, and Resolved-In System options are available if a vector or tensor plot has been generated.

Note - For MinLayer/MaxLayer/ExtremeLayer, the query will return the layer name and the value.

Systems

System ID, System Pool, System Type, Origin Coordinates, X axis, Y axis, and Z axis.

Click the expansion button, exp-button, to bring up the Query Fields dialog.  This dialog lists all the query options currently available (based on the current entity type that is displayed on the input collector).

query_fields_dialog

Query Fields dialog

Query options can also be selected, or deselected, using the All/None/Reverse buttons:

select_all

All options listed are selected.

deselect_all

No options listed are selected.

reverse_selection_icon

Current selection status is reversed.

The following options allow you to generate, manage, and export query data.

Remove duplicates

Removes all duplicates from the queried nodal data.  This option is enabled when either:

The native result binding is set to nodal.

OR

The Average across component boundary option is selected in the Contour or Iso panels.

Note - This option is disabled for all query entity types other than node.

Apply

After you click Apply, the requested data is displayed in the table.  The number and content of the columns in the table depend on the fields selected in the option list on the left side of the panel,

For example, if only the ID and Coordinates options are checked, then only those two columns are displayed in the table.

Clear Table

Clears all data in the table, but does not clear the selection set defined using the input collector.

Export

Click Export to display the Output File dialog, which allows you to save the contents of the table to a text file.  The initial directory displayed is the present working directory, and the default file name "result" is provided.  If you want to open the file in Excel, save the file with a .csv extension.

Advanced…

Click Advanced… to display the Advanced Query dialog.  From this dialog you can input additional query options.

NoteThis option will only be enabled if a contour plot has been applied to the model.

In addition, you can access the following options by right-clicking anywhere within the table:

query_rght-clck_dialog

Copy

Copies all the data from the row(s) selected in the table to the clipboard.

Select




All

All rows in the table are selected and their corresponding entities are highlighted in the graphics area.


None

No rows in the table are selected and their corresponding entities are no longer highlighted in the graphics area.


Reverse

Current selection status is reversed.

Delete

Deletes all rows that are selected in the table.

NoteYou can also sort the data in the table by clicking on one of the selected option headings.
hmtoggle_plus1To query entities using the Query panel:
1.From the Query panel, define the selection set.
-Click the down arrow, down_arrow, to select the entity type (Nodes, Elements, Components, or Systems).
-From the extended entity selection menu, select the entities to be included in the selection set or pick the entities directly on the model.

The reset switch, reset_button will clear the selection (all options).

2.From the options list, check the information you would like displayed in the query table.
3.Click Apply.

The requested information is displayed in the query table.

NoteYou cannot make changes to the query table.  Highlighted cells can be copied and pasted to other programs, using CTRL + C and CTRL + V, respectively.
hmtoggle_plus1To export and save the contents of the query table:
1.From the Query panel, click the Export button.

The Output File dialog is displayed.

2.Select a directory to which you want to save the file.
3.Enter a file name in the File name field, or accept the default file name, "result".

If you want to open the file in Excel, give the file a .csv extension.

4.Click Save.
hmtoggle_plus1To import a .csv file into Excel:

If a .csv file created from a HyperView table is imported directly into Excel, the data may not be imported into the columns correctly.  HyperView exports the various data (vector for example) together into one field, as seen in the example below:

csv_hdi_example1

To import the data into separate columns:

1.Create a new blank Excel spreadsheet.
2.From the Data menu, go to the Import External Data > Import Data option.
Notethe name of the options listed above may vary slightly, depending on the version of Excel that you are using.
3.Select the .csv file that you would like to import and click Open.
4.From the Text Import Wizard:
-Select the Delimited option and click Next.
-Under Delimiters, activate the Comma and Space check boxes and click Next.

This allows you to separate the vector field into three columns.

-Click Finish and OK.
5.Re-label the first row to correct the labels and add columns if needed.
NoteThe example below shows that a column was added (Mag) in order to calculate Magnitude.

csv_hdi_example2

 

See also

Advanced Query

List of Tcl/Tk poIQueryCtrl Class commands