COLUMN and COLUMNS element - Intergraph Smart 3D - Help - Hexagon

Defines the content of the table output during drawing generation. At least one COLUMNS element is mandatory in the .xml configuration file.

Basic syntax:

<COLUMNS>
<COLUMN Name='TAG' Content='NAME' Type='System.Int32'/>
<COLUMN Name='C101' Content='COMPONENT-ATTRIBUTE1'/>
<COLUMN Name='C102' Content='COMPONENT-ATTRIBUTE2'/>
<COLUMN Name='C103' Content='COMPONENT-ATTRIBUTE3'/>
<COLUMN Name='C104' Content='COMPONENT-ATTRIBUTE4'/>
<COLUMN Name='C105' Content='COMPONENT-ATTRIBUTE5' Type='Double'/>
<COLUMN Name='C106' Content='COMPONENT-ATTRIBUTE6'/>
<COLUMN Name='C107' Content='COMPONENT-ATTRIBUTE7'/>
<COLUMN Name='SKEY' Content='M.SKEY'/>
<COLUMN Name='C108' Expression='C105*4'/>
</COLUMNS>

The COLUMN/COLUMNS element contains the attributes listed below.

• Name indicates the name of the column, such as Name="C105". The name is used in filters and expressions and must adhere to the requirements listed below. This attribute is mandatory.

  • Must begin with an alphabetical character.

  • Must contain only numbers and digits (no spaces or special characters),

  • Must not contain any of the following words: And, Between, Child, False, In, Is, Like, Not, Null, Or, Parent, or True.

• Content indicates the property or attribute of the POD object as defined by the Source attribute of the TABLE element. The basic syntax follows the format Content='COMPONENT-ATTRIBUTE1'. This attribute is mandatory if no Expression attribute is present.

  If Source="Components", then the COLUMN element can contain properties and attributes of the component material. In this case, prefix the property name with M., as in Content='M.SKEY' or Content='M.ComponentType'.

• Expression defines the content of the column. The formula can refer to the other columns in the table and can include constants and functions. This attribute is mandatory if no Content attribute is present. The basic syntax follows the format Expression='C105*4'. For a full description of syntax, see Syntax of EXPRESSION statements and FILTER expressions.

• Type specifies the data type of the column. Supported data types are listed below.

  • Int

  • Double

  • String

  • Boolean

  • CharacteristicBore

    

    • CharacteristicBore consists of a string of characters that represent the bores of a component. Multiple values are separated by "x", such as 1.2x3.4 mm. Typically, CharacteristicBore outputs one bore value for most components and two values for a reducing component. More complex component types can have multiple bore values. You should specify the CharacteristicBore data type for the component property CharacteristicBore.

    • Setting Type to CharacteristicBore also enables the software to output conventional nominal size data (6'x4') and a bolt size (1'x3/8') within a single column. In these instances, Isogen Reporting supports using multiple FORMAT and APPLIESTO elements in the corresponding REPORT/COLUMN entry to define the format for each type of output. See Use Case 2 in FORMAT element.

  • PartNumber

    PartNumber consists of a string of characters and can include a period (for example, 1.A). You should specify the PartNumber data type for the component property REPEAT-PART-NUMBER. Doing so ensures that if this value is used to sort the report, Isogen calculates the sort order correctly.

• Value defines a script (in VBScript format) that is evaluated once at run-time. The content of the column is calculated when the script populates the table. The Value attribute supports the full range of VBScript standard functions. For more complex calculations, the Value attribute also supports user-defined VBScript functions. The attribute can also include a macro that is substituted with data from Isogen (for example, $C.COMPONENT-ATTRIBUTE$).

  <TABLE Name="ScriptExample" Source="Components">
  <COLUMNS>
  <COLUMN Name="StringChange" Value=‘Left("$P.PIPELINE-REFERENCE$",4)’/>
  <COLUMN Name="CalculatedValue" Value=‘$C.COMPONENT-ATTRIBUTE4$ * 2’ />
  <COLUMN Name="FunctionCall" Value=‘SetValue("$P.REVISION$","$C.PIPING-SPEC$")’/>

• The VBScript definition is identical to the Get External Data script definition. The standard scripts that are available in Get External Data, such as NZ, PadLeft, and IIF, are also available for Isogen Reporting.
  

  <ISOGEN-REPORTNG>
  <VBSCRIPT><![CDATA[

  Public Function MyScript(Parameter1, Parameter2)
  MyScript=Parameter1 + Parameter2
  End Function
  

  Public Function MySecondScript(Parameter1)
  MySecondScript=PadLeft ( Left(Nz(Parameter1,"AAAA"),4) & "***," ")
  EndFunction]]>
  </VBSCRIPT>
  

• The table can have columns that do not display on the drawing but are used to contain intermediate or calculated values.

• Child COLUMN entries are supported in the REPORT element. See Controlling output and order of report fields in REPORT element.

• Content, Expression, and Value attributes are mutually exclusive.