2011

Query Examples
The examples below illustrate how tags could be used with SQL queries.
■ Selecting all columns from table Test whilst requiring that the column called Entity Handles matches a
category/property pair called Entity Handle/Value and the column called File Name matches the original
filename of the drawing:
SELECT * FROM Test WHERE "Entity Handle" = %prop("Entity Handle","Value") AND “File Name” =
$removeext(%removepath(%sourcepath));
Here the path and the extension of the file name are being stripped, so a file like c:\model\3rdFloorDucts.dwg
would come out as 3rdFloorDucts.
■ Selecting two columns from table Test whilst requiring that the column called Entity Handle matches a
category/property pair called Entity Handle/Value:
SELECT Name,Part FROM Test WHERE "Entity Handle" = %prop("Entity Handle","Value");
■ Selecting all columns from table Test whilst requiring that the column called Value is within a certain range
given by two category/property pairs:
SELECT * FROM Test WHERE Value BETWEEN %prop("Pressure","Minimum") AND
%prop("Pressure","Maximum");
NOTE Tags must not contain white space between the brackets (unless enclosed by quote marks), so
%prop("EntityHandle","Value") works, but %prop("EntityHandle", "Value") does not.
Manipulate Object Attributes
In Autodesk Navisworks, you can manipulate objects’ transforms (translation, rotation, and scale), and also
change appearance (color and transparency) of objects. All object manipulation is carried out in the Scene View.
Any changes that you make to object attributes are considered to be global, (as if they’d been changed in the
original CAD model), and can be saved with Navisworks files. You have an option of resetting object attributes
back to the state they were in when imported from the original CAD files.
Manipulating Object Attributes During Object Animation
You can temporarily modify position, rotation, size, and appearance of geometry objects for animation purposes.
These changes are not global, and can only be saved (or captured) as animation keyframes.
Transform Objects
To transform objects, you can use three visual manipulation tools, or gizmos, available from the Item Tools tab
➤ Transform panel. You can also transform objects numerically.
To get a clearer view of objects as you manipulate them, you can use the Options Editor to adjust the way in
which the current selection is highlighted. For more information, see “
Set Highlighting Method” on page 223.
Using Measure Tools to Transform Objects
You can use the
Measure Tools functionality to move and rotate the currently selected objects.
To move an object with gizmo
1 Select the object you want to move in the Scene View.
2 Click Item Tools tab ➤ Transform panel ➤ Move
.
3 Use the move gizmo to adjust the position of the currently selected object:
■ To move all currently selected objects, place the mouse over the square at the end of the desired axis.
When the cursor changes to
, drag the square on the screen to increase/decrease the translation along
that axis.
244 | Chapter 8 Review Your Model