Anon feedback explorer for user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Based on http://data.stackexchange.com/programmers/query/169976/anon-feedback-explorer get back all anon-feedback for the posts of a given user

Stack Overflow

Q&A for programmers

select
  PF.PostID as [Post Link],
  case P.PostTypeId
    when 1 then 'Q'
    when 2 then 'A'
    else '?'
  end as "Q/A",
  case PF.VoteTypeID
    when 2 then '+'
    when 3 then '-'
    else '?'
  end as "+/-/?",
  count(1) as votecount,
  coalesce (P.viewCount, PP.viewCount) as viewCount
from
  PostFeedback PF
  left join Posts P on (PF.PostID = P.id)
  left join Posts PP on (PP.id = P.parentid)
where
  P.OwnerUserid = ##UserId##
  and PF.IsAnonymous = 1
group by
  PF.PostID, P.PostTypeId, PF.VoteTypeID, P.viewcount, PP.viewcount
order by
  votecount DESC,
  viewcount DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results