Access Data from the Design or Catalogue Databases

DRAW Reference Manual

Intelligent Text : Access Data from the Design or Catalogue Databases

Access Data from the Design or Catalogue Databases

All Design and Catalogue database attributes are accessible. For example, attribute ABCD is 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 can be accessed in the same manner.

A single integer qualifier can 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, for example, W12250 N7890 U3120
#POSE	Easting coordinate only, for example, E12250, W9675
#POSN	Northing coordinate only, for example, N7890, S22150
#POSU	Upping coordinate only, for example, U3120, D250

If you 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] provides the Northing (or Y coord) of the Gross Centre of Gravity position.

Only single index qualifiers are allowed, thus: #GCOFG[2,3] generates 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 Transform 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, for example,W12250 N7890 U3120
#POS+	gives -12250 +7890 +3120
#POSE+	gives -12250
#POS+[3]	gives +3120

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