DECLARE @UserIdParam AS INT = ##UserIdParam:int?6309## SE...

0

Please login or register to vote for this query.

(click on this box to dismiss)

DevOps Meta

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

DECLARE @UserIdParam AS INT = ##UserIdParam:int?6309##
SELECT
  P.LastEditDate, P.Id AS [Post Link]
  FROM Posts P
  JOIN Posts Q ON Q.Id = P.ParentId
  JOIN PostHistory H ON H.PostId = P.Id
  WHERE P.LastEditorUserId = @UserIdParam
  AND P.PostTypeId = 2 -- answers
  AND P.LastEditDate > '11-30-2022' 
  AND H.PostHistoryTypeId IN (5) -- 2: initial body, 5: edit body, 8: rollback body
  ORDER BY P.LastEditDate DESC;
;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results