-
1. Re: Translator Capabilities
rareddy Feb 3, 2014 5:38 PM (in response to tom9729)Yes, that much fine grained capabilities support is not available. Generally you need to detect that situation in code and issue an exception. You can define a column searchable or not, if it is searchable it will be eligible for pushdown for EQUALS and IN and Compare etc.
Ramesh..
-
2. Re: Translator Capabilities
tom9729 Feb 3, 2014 6:40 PM (in response to rareddy)Ramesh,
I am using unsearchable for some fields. The tricky thing is with filter capabilities that depend on the column. What I am thinking of is the ability to specify some capabilities on the columns themselves. For example, column X supports RANGED and EQUALS; columns Y and Z support EQUALS and IN.
Thanks,
Tom
Edit: Really just a clarification of my original post.
-
3. Re: Translator Capabilities
shawkins Feb 4, 2014 2:23 PM (in response to tom9729)1 of 1 people found this helpfulThere have been other users with similar requirements, but typically it has been satisfied with a combination of searchability/capabilities. This still seems to somewhat be straddling the notion of procedural access vs. a view - but that ultimately you want the client to access as a view correct?
Somewhat related to [TEIID-236] Procedural access pattern - JBoss Issue Tracker there is a case to be made for a restriction to just equality, in, is null, which would get you most of the way toward what you are looking for.
Steve