Column Values as Select Expressions

You can get column data based on a select expression applied to a set of OIDs or RELIDs.

The column definition must include a valid select expression for a business object or relationship.

Some examples of select expressions include:


  • type
  • name
  • $<attribute[attribute_Originator].value>
  • $<attribute["Originator"].value>
  • attribute["Originator"].value
  • $<attribute[attribute_FindNumber].value>

The following MQL script snippet defines a table whose column values are select expressions. The first two columns define expressions on business objects and the third has an expression on a relationship.

add table ENCParts system
    column
        name Name
        businessobject name
    column
        name Originator
        businessobject $<attribute[attribute_Originator].value>
    column
        name FindNumber
        relationship $<attribute[attribute_FindNumber].value>