Real Time Information Director User Documentation

RTID Metadata Language
Hewlett-Packard Company 58 529618-002
public InstanceId(String fieldName)
LeftJoin
The LeftJoin enrichment joins one table with another. It causes a “LEFT JOIN
<tablename> ON <onclause>” clause to be added to the SQL statements generated for
this record.
Two mandatory String parameters specify the <tablename> and the <onclause>. An
optional parameter specifies the alias: an “AS” qualifier appended to the join clause. In
the XML output (or input) ,the names of columns obtained from the joined table will be
prefixed by the name specified as the “AS” parameter followed by a dot (.). You must
specify the “AS” parameter if the joined tables have any columns with the same name, in
order to avoid ambiguity both in the SQL statement and in the XML output.
The LeftJoin constructor looks like this:
public LeftJoin (String joinTable, String sqlOn)
throws SQLException, MetadataInconsistency
public LeftJoin (String joinTable, String alias, String sqlOn)
throws SQLException, MetadataInconsistency
Alias
The Alias enrichment specifies an “AS” qualifier for the table listed in the
DocumentRecord or RelatedRecord. In the XML output (or input) the names of columns
obtained from the joined table will be prefixed by the name specified as the “AS”
parameter followed by a dot. The Alias enrichment is generally used prior to the LeftJoin
enrichment so that all columns are fully qualified (with a prefix) in the SQL statement
and in the XML output.
The Alias constructor looks like this:
public Alias(String alias)
ColumnList
The ColumnList enrichment specifies the columns of a record that will be included in a
document. By default—that is, if you don’t use the ColumnList enrichment, all columns
are included, but if you specify the ColumnList enrichment, the SQL SELECT statement
for the record will enumerate the columns you indicate.
The column names can be passed as an array of String, or as a single String containing
names separated by blanks. By default, all columns in the schema of the record are
included in the document.