Anonymous Feedback for a specific question and its answers

6

Please login or register to vote for this query.

(click on this box to dismiss)

Gets: Score, Age, Views, and Anonymous Feedback for a specific post and any answers it may have. (If given an answer-post ID, it just fetches data for that answer.)

Stack Apps

Q&A for apps, scripts, and development with the Stack Exchange API

SELECT top 100      pf.Id
                , SUM (CASE WHEN pf.VoteTypeId = 2 THEN 1 ELSE 0 END)
                AS Helpful
                , SUM (CASE WHEN pf.VoteTypeId = 3 THEN 1 ELSE 0 END)
                AS Unhelpful
    FROM        PostFeedback pf
    GROUP BY    pf.Id

Enter Parameters

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