]
Barry LaFond resolved TEIIDDES-1995.
------------------------------------
Resolution: Done
Added OBJECTTABLE template. TEXTTABLE template is already available. Marking as resolved.
Add templates for OBJECTTABLE, TEXTABLE, etc
--------------------------------------------
Key: TEIIDDES-1995
URL:
https://issues.jboss.org/browse/TEIIDDES-1995
Project: Teiid Designer
Issue Type: Enhancement
Components: Transformations
Affects Versions: 8.4
Reporter: Van Halbert
Assignee: Barry LaFond
Fix For: 9.0.4, 9.2
Attachments: select-object-table-sql-template.png
Add templates for using OBJECTTABLE, TEXTTABLE, etc. to the the list of templates to
apply to the transformation. Example:
SELECT
o.{colname}, o.{colname}
FROM
{ObjectTableName} as T,
OBJECTTABLE('x' PASSING T.{ObjectColumnName}Object as x COLUMNS
{colname} type 'teiid_row.{colname}', ….) as o