10
$\begingroup$

I wanted to check my ancient down votes to see if things have improved:

I tried to make a query on data.se to find my downvotes:

select Name as Type, PostId as [Post Link]
from Votes
join VoteTypes on VoteTypeId = VoteTypes.Id
where UserId = ##UserId##​

but it only shows favorites. I guess it makes sense that we can't view other people's votes, but since we can make data.se accounts and it already looks up our userid based on email hash, can it not also check that we are only looking at our own votes?

Alternatively, is there some other way to see on which questions I still have down votes?

It's hard to check if someone has fixed their answer / question if I don't know what their answer / question is.

$\endgroup$
4
$\begingroup$

You can figure that out by going to https://math.stackexchange.com/reputation and looking for "(-1)".

More details here: How do I audit my reputation?

$\endgroup$
8
  • 3
    $\begingroup$ If someone has been active for many days and wants to find an old downvote this can be a real hassle. $\endgroup$
    – Asaf Karagila Mod
    Oct 24 '11 at 22:29
  • $\begingroup$ @AsafKaragila: Jack wants a list, and this gives it. As to your concern, a little bit of scripting would help cut down the hassle, once you have the complete list, I suppose. $\endgroup$
    – Aryabhata
    Oct 24 '11 at 22:39
  • $\begingroup$ In fact you can find out the classification of the reputation change. Downvoting is 3 (it is in that same page you link) $\endgroup$
    – Asaf Karagila Mod
    Oct 24 '11 at 22:41
  • $\begingroup$ @AsafKaragila: Right, searching for (-1) rather than 3 is probably faster though... $\endgroup$
    – Aryabhata
    Oct 24 '11 at 22:45
  • $\begingroup$ True, but vote type 3 is more useful for an SQL query :-) $\endgroup$
    – Asaf Karagila Mod
    Oct 24 '11 at 22:46
  • $\begingroup$ I don't think data.se will give you any info about individual downvotes, as that is sensitive information. So, unfortunately, the reputation link might be the only way. $\endgroup$
    – Aryabhata
    Oct 24 '11 at 22:48
  • 1
    $\begingroup$ That sure as hell sounds reasonable. Shame :-) $\endgroup$
    – Asaf Karagila Mod
    Oct 24 '11 at 22:50
  • 1
    $\begingroup$ Thanks! I added a simple javascript/bookmarklet filter below. $\endgroup$ Oct 25 '11 at 1:09
4
$\begingroup$

Using Aryabhata's hint, I put a bookmarklet at http://www.ms.uky.edu/~jack/mse.html -- to use it drag the "My Downvotes" link to the toolbar right below the address bar on your browser. It pulls out the downvotes you cast on answers (as opposed to the upvotes and accepts you did, and the downvotes done to you) and links to the answers. It doesn't give names, but it is very fast and simple.

It does not display downvotes on deleted answers, or on any questions. As far as I can tell, those downvotes are permanent and/or lost.

$\endgroup$
10
  • $\begingroup$ I don't have a toolbar below the address bar? $\endgroup$ Oct 25 '11 at 7:51
  • $\begingroup$ @Jyrki: What browser are you using? $\endgroup$ Oct 25 '11 at 8:29
  • $\begingroup$ @J.M. Firefox ver 7. This is probably configurable. I vaguely recall getting rid of a bunch of toolbars, because they took up too much space on the small laptop screen. As things are now, there is nothing between the address bar and the viewing area. $\endgroup$ Oct 25 '11 at 8:59
  • $\begingroup$ Clicking Jack's script only gives me the usual (?) listing from the reputation page with all my reputation changes sorted by date and (presumably) ID# of the question. $\endgroup$ Oct 25 '11 at 9:02
  • $\begingroup$ @Jyrki: Oh yeah, the bookmark toolbar is disabled by default in version 7; you can enable it in View > Toolbars and then checking "Bookmarks Toolbar". $\endgroup$ Oct 25 '11 at 9:02
  • $\begingroup$ @J.M. Ok, I could now drag Jack's link to that area. The output of that script didn't change though. $\endgroup$ Oct 25 '11 at 9:05
  • $\begingroup$ @Jyrki: I need to click the bookmarklet twice if I'm not already on the reputation summary page. The first time I get to the usual view, the second time Jack's script reads out the answers I downvoted and provides links to them. (I'm using FF, too). Maybe this simple thing does the job for you, too? $\endgroup$
    – t.b.
    Oct 25 '11 at 13:28
  • $\begingroup$ Thanks @t.b. Didn't Jack initially tell us to click twice? I was confused and assumed that he told us to "doubleclick". Apparently there is a difference :-) $\endgroup$ Oct 25 '11 at 13:55
  • $\begingroup$ @Jyrki: Yes he did. If it's any consolation, I first had the same misinterpretation :) $\endgroup$
    – t.b.
    Oct 25 '11 at 13:57
  • $\begingroup$ Nice! It worked for me. $\endgroup$
    – Aryabhata
    Oct 26 '11 at 21:19

You must log in to answer this question.

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