Considerations for Attributes Used in SQL Template Designer Queries
The attribute database view, apt_v_server_attribute, is dynamically created from server attributes you enter in the Portal. During the creation of this database view, several rules are applied to facilitate the use of this view in queries in the SQL Template Designer. When you see the attribute names listed in the SQL Template Designer Formatting tabbed window, you'll see that the following conversions have been made to your Attribute Names--that is, the view's column names.
All characters are lowercase.
Special characters, such as ":" or "/" or a space, are converted to an underscore.
If the attribute name begins with a number or a special character, it will be replaced with: c_
If the conversion process results in duplicate names, the attribute name will have a suffix appended to differentiate the duplicates; for example: _1 or _2
Names are truncated to 30 characters.