Creating SQL expression by draging cell values to the filter field
- Dominant language
- Java
- Stars
- 51.8k
- Forks
- 4.4k
- Avg merge
- 3d 13h
- Merged PRs (30d)
- 183
Description
It is often necessary to filter a table depending on the selected values.
The idea is that (like in MS Access) you can select some values,
right click and choose a menu 'Filter > All cell values'
or just drag them to the filter panel above the table.
Draging values to the filter panel now only inserts the names of the selected columns,
but it would be much better to create an SQL expression based on the selected values (columns and rows).
(The column names can be inserted if full columns are selected - as a filter does not make sense then.)
If the following values are selected
Col1 Col2
1 5
2 7
it should result in an SQL expression like (Col1 = 1 AND Col2 = 5) OR (Col1 = 2 AND Col2 = 7).
If the filter panel already contains expressions the new ones should be inserted at the mouse position.
And the focus should jump to the filter panel. (Now the focus stays on the table values.)
Edit: By pressing Shift the rows could be added to an existing filter (OR), with Ctrl removed (AND NOT) - otherwise AND.
The menu could be 'Add cell values', 'Remove cell values' and 'Combine with cell values'
Contributor guide
Assessment
This issue has not been assessed yet.