Accessing Data from the DESIGN or Catalogue Databases

DRAW Reference Manual

Intelligent Text : Accessing Data from the DESIGN or Catalogue Databases

Accessing Data from the DESIGN or Catalogue Databases

All DESIGN and Catalogue database attributes are accessible. For example, attribute ABCD would be accessed by code #ABCD (or #abcd). In addition, any Design element can be accessed. For example:


#SITE	Name of site owning the referenced element
#BRAN	Name of Branch owning the referenced element

AVEVA E3D™ pseudo-attributes may be accessed in the same manner.

A single integer qualifier may be specified to attributes that require them using the optional ^ delimiter. For example "#FLEVEL^2" is equivalent to the command line query Q FLEVEL(2).

The codewords for the more commonly used position attributes can be modified so as to provide only one of the coordinates. For example:


#POS	full 3D position, e.g. W12250 N7890 U3120
#POSE	Easting coordinate only, e.g. E12250, W9675
#POSN	Northing coordinate only, e.g. N7890, S22150
#POSU	Upping coordinate only, e.g. U3120, D250

For users that work in XYZ format the alternative codewords: #POSX, #POSY, #POSZ are provided.

The position attributes that can be modified in this way are: POS, HPOS, TPOS, APOS, TPOS, NPOS, POSS, POSE, DRPS and DELP. Note that the codeword #POSE can have two meanings depending on the context: for SCTNs it means the POSE attribute (Section End Position), in other cases it means the Easting of the POS attribute.

For other position attributes single coordinates can be obtained by using a single index qualifier. For example:

#GCOFG[2] would provide the Northing (or Y coord) of the Gross Centre of Gravity position.

Only single index qualifiers are allowed, thus: #GCOFG[2,3] will generate an error.

The position codewords generate values in World coordinates. It is possible to generate values in the coordinate systems of other elements by the use of transform keywords. Refer to Transforming Position/Direction Data for further information.

Note:

As an alternative to the standard ENU or XYZ formats, positions can be output in '+/-' format by appending '+' to the codeword. For example:


#POS	full 3D position, e.g. W12250 N7890 U3120
#POS+	would give -12250 +7890 +3120
#POSE+	would give -12250
#POS+[3]	would give +3120

1974 to current year. AVEVA Solutions Limited and its subsidiaries. All rights reserved.