What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 133 Stack Exchange communities.

How about adding an option to filter featured questions by the value of their bounty? I.e. I want to challenge questions with bounty above +250 and would like to find them easily.

share|improve this question
Interesting idea! (I would've seen this sooner, but I filter all bounties under 600 points) –  Shog9 Jun 17 '12 at 4:41

1 Answer 1

up vote 4 down vote accepted

I agree this would be a nice feature: http://stackoverflow.com/questions?sort=featured&filter=bountypoints but realistically it is quite a big task.

In the mean time, I whipped up this query that will list questions with bounty's from the start of the month: (direct link)

SELECT P.id As [Post Link], V.BountyAmount, V.CreationDate As [Bounty Start], P.Score, 
  P.ViewCount, P.Title, P.Tags, P.Body, P.AnswerCount 
FROM Posts P INNER JOIN Votes V ON P.Id = V.PostId
WHERE DATEPART(m, V.CreationDate) = DATEPART(m, getdate())
  AND DATEPART(yyyy, V.CreationDate) = DATEPART(yyyy, getdate())
  AND V.BountyAmount > 0
  AND P.ParentId IS NULL
ORDER BY V.BountyAmount DESC, V.CreationDate DESC
share|improve this answer

You must log in to answer this question.

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