5.0

SELECT * FROM Test WHERE Value BETWEEN %prop("Pressure","Minimum") AND %prop("Pressure","Maximum");
The full Tag list includes:
Property tags
• %prop("category","property") - Property of the currently selected object. Category is the name of
the tab in the property windows (e.g. Item or Entity Handle) and property is the name of the
property in that tab. (e.g. Value or Layer)
• %intprop("category","property") - Property of the currently selected object. This is the same as the
previous tag except instead of using the publicly visible category and property name use the
internal JetStream names. The benefit of using internal names is that they are not language
dependent. [This is advanced tag that will make more sense to people familiar with the JetStream
API]
File/Path tags
• %sourcepath – This tag represents the full path and filename that the currently selected object
comes from. Even when a collection of model files have been combined into a single NWD file this
tag will still remember the path and filename of the original model file.
• %currentpath - This tag represents the full path and filename of the currently loaded model. If you
currently have an NWF or NWD loaded that contains many other models it will just return the path
and filename of the top level NWF/NWD.
File/Path Manipulation Tags
• %removeext("text") – If the provided text includes a filename with an extension this tag will remove
the extension.
• %removepath("text") – If the provided text includes a path and filename this tag will remove the
path and just return the filename.
• %poppath("text") – If the provided text includes a path this tag will remove the top level. If it the text
also includes a filename that will count as the top level and be removed. [e.g. %poppath(“c:\temp”)
becomes c:\ and %popath(c:\temp\readme.txt”) becomes c:\temp]
• %pushpath("text1","text2") – If text1 is a path and text2 is a file or folder name then text2 will be
added onto the path in text1. [e.g. %pushpath(“c:\test”,”model.nwd”) becomes c:\test\model.nwd]
String Manipulation Tags
• %join("text","text") – This tag simply joins the two pieces of text together. [For example
DataTools
266