You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/02/04 21:41:07 UTC
[GitHub] [superset] stswn opened a new issue #8452: [SIP-25] Proposal for text based dashboard filters
stswn opened a new issue #8452:
URL: https://github.com/apache/superset/issues/8452
## [SIP-25] Proposal for text based dashboard filters
### Motivation
In our projects analysts need to browse through large dataset (7M rows). They often need to search for rows by values which are unique or have very large number of unique values. Current implementation of dashboard filters is based on limited number of value buckets and does not allow them to do this.
### Proposed Change
Add new visualization type - 'Search Box' which would allow to specify filter values by free typing.
New chart type should at least enable filtering with '==' operator. Additionally every defined filter could allow for different filtering operators to be used:
For text columns:
- contains => `column LIKE '%value%'`
- does not contain => `column NOT LIKE '%value%'`
- starts with => `column LIKE '%value'`
- ends with => `column LIKE 'value%'`
- is empty => `column IS NULL`
- is not empty => `column IS NOT NULL`
For number columns: arithmetical comparison operators.
Similar functionality is already present in chart query configuration section. We would like to see similar functionality on dashboard level available to the end users of the dashboards.
New visualization would not need to perform any queries to render. It would be based on table metadata only.
### New or Changed Public Interfaces
Base version of this improvement containing only ability to filter by exact value(`==`) requires only new visualization to be prepared. It would emit filters in the same way that 'Filter Box' and 'Table' charts do.
Extended version requires changes in how filter state is stored on Dashboard level - it should contain information about used comparison operator. Also new addFilter action should be added and `getEffectiveExtraFilters` function should be extended.
### New dependencies
None
### Migration Plan and Compatibility
n/a
### Rejected Alternatives
Existing 'Filter Box' visualization could be extended to allow for free input, but it is probably better to separate slice which performs query from one which can be rendered without fetching any data.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] rusackas commented on issue #8452: [SIP-25] Proposal for text based dashboard filters
Posted by GitBox <gi...@apache.org>.
rusackas commented on issue #8452:
URL: https://github.com/apache/superset/issues/8452#issuecomment-824369343
This is covered by the Dashboard Native Filters feature released with 1.0, which can be enabled by feature flag. Please let me know if I'm misunderstanding any intent. If so, we can re-open, update some context here, and take it to a VOTE if needed. Thank you!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] rusackas closed issue #8452: [SIP-25] Proposal for text based dashboard filters
Posted by GitBox <gi...@apache.org>.
rusackas closed issue #8452:
URL: https://github.com/apache/superset/issues/8452
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] rusackas commented on issue #8452: [SIP-25] Proposal for text based dashboard filters
Posted by GitBox <gi...@apache.org>.
rusackas commented on issue #8452:
URL: https://github.com/apache/superset/issues/8452#issuecomment-1030371170
Reopening since Native Filters doesn't *quite* cover what this SIP asks for. Technically this is discussion, so we'll leave it there.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org