Page 1 of 1

Color by column

PostPosted: Tue Jan 05, 2016 2:04 pm
by 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
colorby.png (17.57 KiB) Viewed 21455 times

colorby2.png
colorby2.png (10.2 KiB) Viewed 21455 times

colorby3.png
colorby3.png (12.04 KiB) Viewed 21455 times


Hope this makes sense. What do you think?

Amos.

Re: Color by column

PostPosted: Tue Jan 05, 2016 2:07 pm
by 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.

Re: Color by column

PostPosted: Tue Jan 12, 2016 12:11 pm
by Serge
Interesting feature, I like it.
Could you add feature request on GitHub - https://github.com/serge-rider/dbeaver/issues ?

Re: Color by column

PostPosted: Thu Jan 21, 2016 9:43 am
by amosmoss

Re: Color by column

PostPosted: Mon Jan 25, 2016 4:50 pm
by amosmoss
Hi,

First of all thanks for the feature :D . 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.

Re: Color by column

PostPosted: Mon Jan 25, 2016 5:52 pm
by Serge
Please create a new issue on GitHub.
Briefly:
1. Can't reproduce that. Could you attach a screenshot
2. Please give an example

Re: Color by column

PostPosted: Tue Jan 26, 2016 8:43 am
by 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
distinct.png (17.94 KiB) Viewed 20613 times


* color lines based on gradient numeric values (like conditional formatting in excel):
grad.png
grad.png (55.11 KiB) Viewed 20613 times


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

Thanks, Amos.

Re: Color by column

PostPosted: Tue Jan 26, 2016 11:30 am
by 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

Re: Color by column

PostPosted: Tue Feb 02, 2016 12:48 pm
by amosmoss