Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

Wouldn't be nice if results in Data Explorer could link to the post they result in?

Please provide a link function that takes a PostId and returns a link to that post.

For example

-- Great Answers
-- Lists the answers a user owns that are eligible for the Great Answer Badge
SELECT P1.Score, P1.Id, P1.ParentId, P2.Title, link(P1.Id) as 'Link'
FROM Posts as P1  -- find responses of questions
JOIN Posts as P2 --And the question it responds to
ON P1.ParentId  = P2.Id
WHERE P1.PostTypeId = 2                 -- answers
AND P1.OwnerUserId = ##UserId##       -- by you
AND P1.Score > 100 --Which a score of over 100
share|improve this question
up vote 5 down vote accepted

It's already possible.

select p.Id as [Post Link] from Posts p
share|improve this answer

You must log in to answer this question.

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