Skip to Main Content
Spotfire Ideas Portal

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

  • Attach files
      Drop here to upload
    1 MERGED

    Please allow us to limit data using aggregated methods when using in-database data

    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...
    over 6 years ago in Spotfire / Data Access 0 Future Consideration
    16 MERGED

    Limit data in connectors

    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...
    about 7 years ago in Spotfire / Data Access / Data Management 3 Future Consideration
    1 MERGED

    Add constraints while loading data from a big data source

    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...
    about 6 years ago in Spotfire / Data Management 0 Future Consideration