What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 150 Stack Exchange communities.

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

1 Answer 1

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
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
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 .