Real Time Information Director User Documentation

RTID Metadata Language
Hewlett-Packard Company 59 529618-002
The ColumnList constructor looks like this:
public ColumnList (String[] columnNames) // Array of columnNames
public ColumnList (String columnNames)
OrderBy
The OrderBy enrichment specifies the order in which records must be returned in an
outbound (query response) document. By default, rows are returned in the order returned
by SQL/MX when no “Order By” clause is specified.
The parameter specifies the SQL clause that will follow the SQL keywords "ORDER
BY" in SELECT statements generated by the Director. The clause consists of one or
more column names separated by commas, with the optional keywords "ASC" or
"DESC" (ascending or descending) following each column name.
The OrderBy constructor looks like this:
public OrderBy (String orderByClause)
Example:
new OrderBy("CO.CARDID, CO.CHECKOUTDATE, T.LASTNAME, T.FIRSTNAME,
T.TITLE")
Condition
The Condition enrichment adds a condition to SELECT and DELETE statements for a
record, to reduce the number of rows affected by the operation.
The parameter is a string specifying the condition:
public OrderBy (String condition)
Example:
new Condition("CI.DUEDATE < CURRENT_DATE AND CI.RETURNEDDATE IS NULL")
VirtualColumn
The VirtualColumn enrichment associates one or more columns with a record, for use by
inbound enrichments or for delivery to a client. These columns aren’t actually stored in
the database.
The parameter is either an array of String, with each element specifying a column, or a
single string that includes all the column names, separated by spaces:
public VirtualColumn (String[] columnNames) // Array of columnNames