Teiid Spring Boot: @SelectQuery supports of where clause parameters

Question

From my understanding, @SelectQuery will return all data of columns defined. What if I would like to restrict data return from the query by adding where clause with parameterized filter?

For example, the following SQL query support filter by ssn:

SELECT id, name, ssn FROM mydb.customer 
WHERE ssn in :ssn

:ssn is valid list of SSNs.

In short, is Teiid Spring Boot support parameterized view?

Please advise. Thank you.

what if you do WHERE mydb.ssn in :ssn – Safwan Shaikh Jan 06 '20 at 10:25 — Safwan Shaikh, Jan 06 '20 at 10:25

score 0 · Accepted Answer · answered Jan 06 '20 at 23:19

0

At entity definition level you can not parameterize the where clause like ":ssn", if you want can supply a static value or referenced value like a = b is fine.

answered Jan 06 '20 at 23:19

Ramesh Reddy

554
1
3
8

Thanks for quick response. Unluckily, the value is dynamic (cannot be static), any alternative way to restrict the data return from entity instead of all data? – limcheekin Jan 07 '20 at 02:34
If it is dynamic it needs to be in the user query. – Ramesh Reddy Jan 07 '20 at 13:47

Teiid Spring Boot: @SelectQuery supports of where clause parameters

1 Answers1