Dynamic Query

Note: The Dynamic Query is re-engineered from Quadri for Windows 2022.3.

General

Dynamic Query is used to select/query features from the model, typically as input to a task.

Dynamic Query has 3 main filters for selecting features; Tasks, Features (types), and Location.

The 3 filters can be combined, and when they are combined, you get the features that match all filters in use.

When you use Dynamic Query, a response in available graphical windows, where all selected features will be marked as selected.

You can mark several instances using SHIFT or CTRL, then press SPACE on the keyboard to select the instances.

The picture below shows the principle of using the Dynamic Query:

Select All

In some cases, you just want to select the whole model, e.g. when making a plan or 3D presentation. In that case, check the Select All button.

To go back to the page with select all, click twice on one of the filter buttons (Tasks, Features, Location), and the page with the Select All check box is loaded.

NB! When working toward a server, where the model can be huge, you should be careful with using the Select All possibility. Select All, in this case, means Select All in the workset, and not the whole model. This will give varying results, depending on the features you actually have downloaded to your workset.

Date of Interest

Includes objects where the following conditions for the “Valid time period” are met:

Tasks

Click the Tasks button to set up a query based on one or more tasks.

When you select a task, you select this task's resulting features.

For example, selecting a road design task means selecting all the features produced by this task.

Or, if you select an import task, you select the features that were imported by this task.

Selecting a task is thus a way of selecting a specific set of feature instances.

To find out what is the resulting features of a task, right-click the task in Explorer and select Show in Plan, or Show in 3D. The window will present only the resulting features. Or, click Select Result to select the resulting features. They will be shown as selected in all windows where they are represented.

Search for specific task names, by entering a text here:

Right-click any of the column headers to get more column options:

Column chooser lets you insert more columns for more information and filtering options. You can drag and drop the columns you want in the view, or right-click and select Hide This Column to remove:

You can drag-and-drop a column header to group by that column:

Picture below shows where both Type and Process structure is used for grouping simultaneously:

Features

Click the Features button to specify the types of features to include.

If you first have selected one or more tasks, you will only see features within those selected tasks. You will also see how many features of the selected tasks you have from a total in the whole model. The picture above shows where no tasks are selected, thus you see all features in the model.

The picture below shows an example of when an import task was selected under Tasks, then the TrafficBarrier feature. 

Note: A total of 98 features are selected; they are marked red in the window when selected.

Global attribute filter

Instead of selecting features based on the features themselves, you can select based on the global attribute filter throughout all the features.

Either click on the white field, or the icon, and select Add filter.

When the filter is activated, you can now click Add Row, Add Group and Delete Filter:

Select one, or multiple, attributes, a comparer, and a value.

List of comparers you can use

The picture below shows an example in which the attribute textureName is used with a comparer contain (case insensitive) and the value is "plastic".

All features in the model with this filtering will then be selected.

Note:  If you select multiple attributes in the filter, you will have to select an operator:

Feature attribute filter

Show the feature filter by clicking the funnel icon for the selected feature type.

Here you can create those same filters, but only for the selected feature type, instead of global for all features.

Location

Click the Location button to specify a geographic limitation for the selection.

Click the icon to define:

Example in which a location shape is added, and only features inside the polygon will be selected:

Updates dynamically

Selecting a task also implies that later on, if the task you have selected changes (you re-import a new version of that file), then you will get the new features that were imported. Thus, the task filter is dynamic.

Process-Based

In some cases, e.g. when defining the calculation basis for a new road task T2, you will see that the Dynamic Query dialogue is named 'Process Based Query'.

In these cases, you are forced to first select tasks.

Dependencies are created between the task you are defining, and the task(s) you select as input. An example:

Now the Quadri model knows that task R1 is dependent upon task G1. Task R1 is longer down the timeline than G1. This is used for handling priority or sequencing the tasks.

Query methods in tasks

Hold the CTRL key on the keyboard and select objects from the window to add/remove objects to the query. If you select an object already included in the query, the object will be removed from the query. If you select an object not already in the query, the object will be added to the query.

NB: If selected, you select the tasks query, and not the task itself.

Next topic: Navigation