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:

AVEVA E3D Design 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 Center 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. See 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