Query builder for AIM data
- Last UpdatedDec 17, 2025
- 3 minute read
The query builder allows you to construct detailed searches including keywords, types, and multiple parameters. It allows you to easily find asset information including documents, tags, events, tasks, locations, 3D models, physical equipment, and activity.
The query parameters use the classes, attributes, and relationships that your Asset Information Management Advanced (AIM-A) administrator has defined in the class library. To use the query builder, you should be familiar with these classes, attributes, and relationships.
Create and execute a query
To create and execute a new query:
-
Select Create from the navigation rail, then select Query.
-
Enter any keywords in the Enter Search Text field.
Note: Only exact matches are not returned. Use wildcard characters for partial keywords.
-
To narrow your search to particular types of asset information, select the Types field and select the types you want to search for.
-
Add query parameters:
-
Select the Add button, then select Attribute or Related Item. The parameter is added.
-
Set the desired values for the parameter.
-
If one or more parameters have already been added, select whether the additional parameter uses AND or OR logic.
-
-
Select Run to run the query.
The search results display below the query.
-
To save the query:
-
Select the save icon near the top right of the page. The Save Query dialog appears.
-
Enter a unique name for the query.
-
Select Private (only visible to you) to make the saved query only visible to you. Otherwise all users will be able to load and run the query.
-
Select Save.
-
Load and execute a saved query
To load a saved query:
-
Select the Saved queries box near the top right of the page. A dropdown of saved queries appears.
Enter text in the box to narrow results down to matching saved queries.
-
Select a saved query.
-
Select Run to run the query.
To load another different query, delete the contents in the Saved search box.
Manage saved queries
To manage saved queries, select Manage saved searches near the top right of the page. From the Manage Saved Searches dialog, you can delete saved queries.
Wildcard characters
The following wildcard and special characters are supported:
-
* (asterisk) and % (percent): Use either * or % to indicate any number of characters.
-
_ (underscore): Use _ to indicate a single character.
-
[ ] (square brackets): If searching for an object that contains a special character, put the special character instead square brackets. For example, [*].
Filter and sort results
The following options are available to filter and sort the query results:
-
To sort by a column, select that column header. Select the column header again to reverse the sort order.
-
Select the filter icon
to toggle the filter boxes. Enter the values you wish to filter by in the appropriate
boxes.
Manage columns
To add and arrange the query result columns:
-
Select Manage Columns. The Manage Columns pane appears.
-
Select Add column, then select the column to add.
-
To rearrange an added column, select the move icon
and drag it. Select the remove icon 
to remove it.
Only added columns can be arranged or removed. The default columns (ID, Name, and Type) always appear as the first three columns and cannot be rearranged or removed.
-
Select Save.
Export search results
To export search results to an Excel or CSV file:
-
Select Export. The Export Search Results dialog appears.
-
Select the format to export to, and whether to include associated documents.
-
Select Export to export the results.
Note: If you have added columns through Manage Columns, some data from the columns may not be included. The export file only includes data for attributes that are directly available on the entities. Attributes coming from related datasets are not included in the export file.