[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-3141) ADD Create View from Model With Criteria.
[
https://issues.jboss.org/browse/TEIIDDES-3141?page=com.atlassian.jira.plu...
]
Van Halbert commented on TEIIDDES-3141:
---------------------------------------
Why hardcode the value, in this example '201711'? Why not try one of the
following:
- use ENV('KEY') in the criteria, where KEY references system property
- use internal materialized table that contains name=value pairs for dynamic environment
setting. Using the join to the internal table to derive the yyyymm value.
This way your VDB doesn't have to be changed with every date change.
However, that doesn't change the core aspect of this feature request, which still
would be useful.
ADD Create View from Model With Criteria.
-----------------------------------------
Key: TEIIDDES-3141
URL: https://issues.jboss.org/browse/TEIIDDES-3141
Project: Teiid Designer
Issue Type: Enhancement
Reporter: Tom Johnston
In some environments (Data Lakes etc) it is likely that one would have a time-metric to
query from.. (i.e. snapshot_year_month) where one might want to create a custom view
model for the latest dataset. As such, a query such as Select * from Table where
snapshot_year_month = '201711' might be used OR (as in my case)...Regardless on
how its used.. the ability to add a FIXED Criteria to ALL objects for a model would be
immensely useful.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)