Color by column

Feature requests and their debate

Color by column

Postby amosmoss » Tue Jan 05, 2016 2:04 pm

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 21927 times

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

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


Hope this makes sense. What do you think?

Amos.
amosmoss
 
Posts: 48
Joined: Thu Dec 06, 2012 7:19 am

Re: Color by column

Postby amosmoss » Tue Jan 05, 2016 2:07 pm

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.
amosmoss
 
Posts: 48
Joined: Thu Dec 06, 2012 7:19 am

Re: Color by column

Postby Serge » Tue Jan 12, 2016 12:11 pm

Interesting feature, I like it.
Could you add feature request on GitHub - https://github.com/serge-rider/dbeaver/issues ?
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Color by column

Postby amosmoss » Thu Jan 21, 2016 9:43 am

amosmoss
 
Posts: 48
Joined: Thu Dec 06, 2012 7:19 am

Re: Color by column

Postby amosmoss » Mon Jan 25, 2016 4:50 pm

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.
amosmoss
 
Posts: 48
Joined: Thu Dec 06, 2012 7:19 am

Re: Color by column

Postby Serge » Mon Jan 25, 2016 5:52 pm

Please create a new issue on GitHub.
Briefly:
1. Can't reproduce that. Could you attach a screenshot
2. Please give an example
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Color by column

Postby amosmoss » Tue Jan 26, 2016 8:43 am

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 21085 times


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


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

Thanks, Amos.
amosmoss
 
Posts: 48
Joined: Thu Dec 06, 2012 7:19 am

Re: Color by column

Postby Serge » Tue Jan 26, 2016 11:30 am

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
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Color by column

Postby amosmoss » Tue Feb 02, 2016 12:48 pm

amosmoss
 
Posts: 48
Joined: Thu Dec 06, 2012 7:19 am


Return to Feature Requests



Who is online

Users browsing this forum: No registered users and 2 guests