Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

While writing a query in the Data Explorer, I nearly always have to interrupt the process to query the VoteTypes, PostTypes, and / or PostHistoryTypes tables (so I can remember the Ids I need). I think it would be convenient to have access to the values in those tables directly from the UI (without having to do SELECT * FROM VoteTypes).

Could we have something like that?

I realize I could save the values from those tables somewhere on my computer, but they'd (possibly) get out-of-date periodically, and if new "____Types" tables are added, I'd have to manually update my local list.


I'm not a UI person, but here's a possible implementation: next to each of these "____Types" tables, add a link you can click that pops up a list of the values from that table (incredibly awesome* mock-up below):

These are not the Post History Types you're looking for

I'm not married to this specific implementation, anything reasonable would do. This feature-request just seemed too lazy without some kind of suggested solution =)

*Awesomeness may vary. We offer no actual guarantee (implied or explicit) of awesomeness regarding the mock-up.

share|improve this question
2  
I use this in another tab and would prefer to have the data in the UI too. – Gilles Mar 22 '12 at 13:35
    
@Gilles That query was a great idea! I wish I would have thought of that months ago. – jadarnel27 Mar 22 '12 at 15:46
up vote 7 down vote accepted

Yes, you can, actually.

I've already got a prototype implementation of this that I'll be tightening up this weekend and passing along to waffles for review.

Update: This is done now (provided there's no major issues with my implementation). I'll be pushing it out to my repository later tonight after make a few other changes.

Some screenshots of what it looks like:

icon to indicate there's a helper view

...which you click to open the helper view as an overlay to the side bar:

open helper view

share|improve this answer
    
Great minds think alike! I look forward to see this =) – jadarnel27 Mar 22 '12 at 13:42
1  
I had something come up this weekend, so unfortunately still not quite there. :/ Working on it though... – Tim Stone Mar 26 '12 at 12:18
1  
Yes, I see that something came up ;-) – jadarnel27 Mar 26 '12 at 15:00
    
This was a less enjoyable something. :P – Tim Stone Mar 26 '12 at 15:53
    
The magical green checkmark is yours! – jadarnel27 Apr 9 '12 at 14:21
    
@TimStone Have you already added it to the repository? – Idolon May 21 '12 at 12:45
    
@Idolon I did a while back, yeah. It isn't deployed to the live site yet, though. – Tim Stone May 21 '12 at 12:56

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .