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##;

with PostQuestionMappings as (
  select p.Id,
    p.ParentId,
    IsNull(p.ParentId, p.Id) as QuestionId,
    p.Score,
    IsNull(p.Tags, q.Tags) as Tags,
    p.CommunityOwnedDate
  from Posts p
  left outer join Posts q on (q.id = p.ParentId)
  where p.OwnerUserId = @UserId
)

select v.CreationDate,
  v.PostId as [Post Link],
  v.BountyAmount,
  v.VoteTypeId,
  vt.Name,
  p.Tags
from PostQuestionMappings p
join PostTags pt on (p.QuestionId = 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 t.TagName = @TagName
order by v.CreationDate desc

view current version

edited jun 23 12

created jun 23 12 krock