Static filters in in-database connectors (remove rows)
It should be possible to filter out rows based on an expression as global filter attributes.
E.g. CREATED date > sysdate-365 or ROW_NUM<1000001 (Useful when debugging queries that have long run time to load a data subset
1
MERGED
Please allow us to limit data using aggregated methods when using in-database data
Merged
We have a large number of clients and need interactive dashboards based on in-database data. Being able to set to data in part of the field or limit for a recent period would be enormously useful. Is there a reason that we are limited for this? An...
As an addition to today's support for prompts in data connections this feature would add the ability to define a static limit to data in a data connection. This could for example be done by specifying unique values from a column or by writing a cu...
Add constraints while loading data from a big data source
Merged
While loading data from any information link or other database, there should be an option to filter out the data on condition basis. Applying where or having clause in the script or load time will help user to extract only relevant data from an ex...