1

Please login or register to vote for this query.

(click on this box to dismiss)

Show my vote history for a specific tag. VoteTypeFilter is optional, but the UI forces you to at least throw a space in there. The filter is a case insensitive filter on the VoteType column so you can enter 'up', 'accepted' or 'bounty' for example to filter those. For a full list of vote types see http://data.stackexchange.com/stackoverflow/query/73707/list-of-all-votetypes.

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

declare @UserId int = ##UserId##
declare @TagName varchar(25) = ##TagName:string##

select v.Id,
  v.PostId as [Post Link],
  v.CreationDate,
  v.BountyAmount,
  v.VoteTypeId,
  vt.Name
from Posts p 
join PostTags pt on (p.Id = pt.PostId)
--join Tags t on (pt.TagId = t.Id)
join Votes v on (p.Id = v.PostId)
join VoteTypes vt on (v.VoteTypeId = vt.Id)
where p.OwnerUserId = @UserId
--  and t.TagName = @TagName
order by v.CreationDate desc

view current version

edited jun 23 12

created jun 23 12 krock