[teiid-issues] [JBoss JIRA] (TEIID-2798) Add creation of view when exposing metadata via Object translator

[Van Halbert (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12935071#comment-12935071 ] 

Van Halbert commented on TEIID-2798:
------------------------------------

I didn't realize that the Object didn't need to be modeled in order to query the object.   So what your saying is the documentation isn't complete on the options on how to use the Object translator.   
                
> Add creation of view when exposing metadata via Object translator
> -----------------------------------------------------------------
>
>                 Key: TEIID-2798
>                 URL: https://issues.jboss.org/browse/TEIID-2798
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Misc. Connectors
>    Affects Versions: 8.4.1
>            Reporter: Van Halbert
>            Assignee: Van Halbert
>
> When the metadata is exposed for the java object via the Object translator, a view should also  be created using a template similar to:
> SELECT 
>      		    t.{pkKeyField}, o.{colname}, o.{colname} 
> 		FROM Order
>     		    {ObjectSourceTable} as T,
>       		    OBJECTTABLE('x' PASSING T.{ObjectTypeName}Object as x COLUMNS
>       			{colname}  {type}  'teiid_row.{colname}',  ….) as o
> 		where
> {pkKeyField} is the primary key column to the cache
> {ObjectSourceTable} is the source table imported above
> {ObjectTypeName} is the column added in {ObjectSourceTable} to reference the cache object
> {colname} is the name of the columns that have “get” methods, see the {ObjectSourceTable} for columns to use
> {type} is the data type for this column

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira