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.

Consider the following situation:

  • I downvote a question / answer with a comment
  • The answerer / asker edits the question and improves it

In that case, I think the downvote should be removed.

I know it's possible to find my downvotes by going to:


but that requires me going to each and every post, check if it was edited etc. I was wondering if it can be done with the StackExchange Data Explorer.

I've looked at the existing queries searched for a similar one but couldn't find anything except this and this.

(I've seen this answer by Jeff and this is just a personal view)

So, my question is: how can I list the posts that I downvoted that were edited later?

share|improve this question
Voting is anonymous. So we can't find data related to voting in Data Explorer. – hims056 Sep 8 '13 at 16:53
@hims056: Even my votes? – Amal Murali Sep 8 '13 at 16:54
Yes. Because the Data Explorer is public. – hims056 Sep 8 '13 at 16:55
All your downvotes are listed on your profile under votes. Your downvote also shows as an orange arrow - is there a time limit this shows? If no time limit then you can see it there. Also hovering the arrow confirms as the popup text says "click again to remove". This should be enough, as you've already revisited the question. – James Sep 8 '13 at 17:05
Hmm...this gives me an idea. – Tim Stone Sep 8 '13 at 17:26
Can this be a considered as a new feature-request instead? – Amal Murali Sep 8 '13 at 17:33
@AmalMurali I already have proposed one a few months ago, which contains some more functionality as well: meta.stackexchange.com/questions/186579/… – Manishearth Sep 8 '13 at 19:02

1 Answer 1

up vote 9 down vote accepted

As explained who voted is not contained within the Data Explorer as that would involve making downvotes public.

What you're suggesting would be a nice to have for the good citizens who go back1. If you are a good citizen, and always explain how the post could be improved, you could look for posts that were edited by the OP after your comment and where there was a downvote prior to the OPs edit. You can't know who downvoted but you can check if one occurred.

select p.id as [Post Link]
     , max(c.creationdate) as [Last Commented]
     , max(ph.creationdate) as [Last OP Edit]
     , max(p.closeddate) as [Closed]
  from comments c
  join posts p
    on c.postid = p.id
   and c.userid <> p.owneruserid
   and p.lasteditdate > c.creationdate
  join posthistory ph
    on p.id = ph.postid
   and p.owneruserid = ph.userid
   and ph.creationdate > c.creationdate
  join votes v
    on p.id = v.postid
   and v.creationdate < ph.creationdate
 where c.userid = ##userid##
   and p.posttypeid = 1
   and ph.posthistorytypeid = 5
   and v.votetypeid = 3
 group by p.id
 order by max(ph.creationdate) desc

Here's the Data.SE query.

1. I probably wouldn't use it much as if I've commented I check back to see if the OP has replied but not thought to tell me about it.

share|improve this answer
Yes, sir. If there was a Citizenship tab in the help center, it should include the link to this query. – brasofilo Sep 22 '13 at 16:04

You must log in to answer this question.

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