dbeaver / dbeaver/dbeaver

Copy as Where

Open
#18,779 3 comments 0 reactions 0 assignees View on GitHub
xf:data xf:sql
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

**Is your feature request related to a problem? Please describe.**
I am frustrated when I need to check data in a table (for example, to identify a problem of incorrect duplication of some rows) and in DBeaver I cannot use in the data table the "copy as where" funcionality as I always did with SQuirre-Sql.

**Describe the solution you'd like**
The "copy as where" in SQuirreL-Sql works like this:
1. Execute a query:
![image](https://user-images.githubusercontent.com/54542143/212656747-8f7ac12c-cbf4-4572-a8c1-d666adab87b5.png)
2. You select some cells in the data table and in the right-click menu you select "copy as where".
![image](https://user-images.githubusercontent.com/54542143/212656956-cdfb4027-b5c5-46f5-93f8-1caebd4ae937.png)
4. Then you just paste (Ctrl-V) the result into the sql edit to have a where that selects only the rows that have the selected characteristic.
![image](https://user-images.githubusercontent.com/54542143/212657083-a748c600-db32-48fd-8d36-cebccf66ff80.png)

**Describe alternatives you've considered**
Any functionality that by selecting certain cells in the results table (e.g. 'foo' in column colA, 12.4 in column colB and 2022-12-03 in column colC) would allow you to directly create a string like this:
``colA='foo' and colB=12.4 and colC='2022-12-03'``

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.