In the Stack Exchange Data Explorer, some of the small tables have an (i) button, which upon clicking shows you the contents of that table. This saves you a SELECT * FROM VoteTypes if you couldn't remember the ID for upvotes.

enter image description here

My request it to add this as well for two other tables: ReviewTaskStates and ReviewRejectionReasons. Both are small enough (comparable to the sizes of other tables for which the feature is enabled).

enter image description here enter image description here

1 Answer 1


In the following class the default can be changed

public class HelperTableCachePreferences
    public HelperTableCachePreferences()
        PerSite = false;
        IncludePattern = ".*(Types|TaskStates|RejectionReasons)$";
    /// other code omitted

but the settings get instantiated by the AppSettings class anyway, which get its values from either appSettings.config file or the AppSettings table found in the DataExplorer database. The setting in the config or the row should look like this:

<add key="HelperTableOptions" 
     value="{ PerSite: false, IncludePattern: '.*(Types|TaskStates|RejectionReasons)$' }"/>

I tried it locally and it worked for me, YMMV.

Give Nick 6 to 8 weeks to change this.

  • This hasn't been changed (even after waiting 6-8 months). Would it make sense to make a PR?
    – Glorfindel Mod
    Commented Jul 26, 2017 at 7:50
  • @Glorfindel I can prep the PR but it still needs Nick to alter the settings table in the db. Only a PR is not going to cut it.
    – rene
    Commented Jul 26, 2017 at 8:02
  • OK, sad :( ....
    – Glorfindel Mod
    Commented Jul 26, 2017 at 8:03
  • Asked some support from Tim here
    – rene
    Commented Jul 26, 2017 at 8:12

You must log in to answer this question.

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