2012

String Manipulation Tags
%join("text","text") This tag simply joins the two pieces of text together. For
example, %join(“c:\”,”model.nwd”) returns c:\model.nwd.
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 Navisworks Simulate, 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
382 | Chapter 7 Review Your Model