Color by column

[amosmoss]

Hi,

I just came up with a crazy thought. I was passing over a query's records, looking at some column at the end of the records, but every now and then I had to check that one of the columns at the beginning of the record has not changed.

And then I thought that sliding back and forth of the record's column is stupid, and thought that it could be great if by left-clicking the column name (at the beginning) I could choose a color by option, and then all the records colors will change according to its value (from a preset color theme). If the field is numeric/date, the color could be gradient.

Here are my mspaint simulations for the (imagined) looks of it:

colorby.png (17.57 KiB) Viewed 20890 times

colorby2.png (10.2 KiB) Viewed 20890 times

colorby3.png (12.04 KiB) Viewed 20890 times

Hope this makes sense. What do you think?

Amos.

[amosmoss]

Hi,

I've bumped this 2 year post, because I often find myself in need of such feature. ppl, please comment on this if you think it'll help you too.

Thanks, Amos.

[Serge]

Interesting feature, I like it.
Could you add feature request on GitHub - https://github.com/serge-rider/dbeaver/issues ?

[amosmoss]

Done.

https://github.com/serge-rider/dbeaver/issues/168

Sorry for the delay.
Amos.

[amosmoss]

Hi,

First of all thanks for the feature . I will most certainly use it a lot, and I'm sure others will too...

1. There's seems to a bug, though. The coloring won't work if the connection type color is not white.
2. Auto coloring would also be nice. For char fields, you can assign color by its value's hash, and for numeric fields, you can assign a gradient color that spans the minimal and maximal values.

Thanks again, Amos.

[Serge]

Please create a new issue on GitHub.
Briefly:
1. Can't reproduce that. Could you attach a screenshot
2. Please give an example

[amosmoss]

1. Sorry, there's no relevant screenshot, because nothing happens when I choose to color by the column name and choose color.
2. Here are two examples for auto coloring:
* color lines based on distinct string values:

distinct.png (17.94 KiB) Viewed 20048 times

* color lines based on gradient numeric values (like conditional formatting in excel):

grad.png (55.11 KiB) Viewed 20048 times

What would you like me to open an issue on? The bug or the Auto coloring feature?

Thanks, Amos.

[Serge]

1. Maybe some info about connection type? Steps to reproduce?
2. Got it.

I think it should be 1 bug report + 1 feature request.
Regards

[amosmoss]

Created two new features:
https://github.com/serge-rider/dbeaver/issues/186
https://github.com/serge-rider/dbeaver/issues/185

Thanks.