'selectable=false' on virtual table

[prashanthi1]

Hi,

I am trying to make a field in a virtual table as 'selectable=false', so that I do not get that field in odata get response.

But i am getting error : TEIID30492 The following data elements are not supported in the SELECT clause: [g0.FIELD_NAME]

my sql is -> select * from table.

how to make a field not appear in odata get response (i cannot delete this field as i need this field for some other purpose)?

Thanks in advance

Prashanthi.

[rareddy]

You define $select on the odata URL and define all the columns you want, or create another view of the same table without the that particular column exposed.

BTW, what is behavior through JDBC? If that is allowing "select *" and not returning the column, then we will consider the enhancement for OData.

Ramesh..

[prashanthi1]

Hi Ramesh,

thanks for the reply. when I try Preview Data from Teiid designer, I do not get the columns that I updated 'selectable=false'.

I expected odata to behave the same way. But I get this error.

thanks,

Prashanthi.

[rareddy]

Try using JDBC client, like SQuirreL, if the same behavior then you can log a JIRA.

[shawkins]

I think what you are seeing is that if you don't specify $select, the ODataSQLBuilder does not filter non selectable columns from the generated Teiid query (if we internally were using select * instead, then this would work as expected).  So yes that needs an issue to fix.

[shawkins]

This was logged and worked as [TEIID-3698] non-selectable columns will cause OData failures - JBoss Issue Tracker

[prashanthi1]

Can we do this by using column masking? to not to show a column in odata response?

[rareddy]

selectable or not, column masking is two different features. selectable defines if column can be selected, masking shows the column but can mask the data with whatever you want. If you want the column to show up for all users but show different values for each logged in user then column masking is what you are looking for.