1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT TOP(##num?100##)
PostId AS [Post Link],
url = 'site://suggested-edits/'+CAST(Id AS varchar),
CreationDate,
CASE
  WHEN ApprovalDate IS NOT NULL THEN 'Approved'
  WHEN RejectionDate IS NOT NULL THEN 'Rejected'
END,
OwnerUserId AS [User Link],
Comment, ApprovalDate, RejectionDate
FROM SuggestedEdits
WHERE (OwnerUserId=##UserId##)
    AND (CreationDate >= '##Date1?2022-04-01##') AND (CreationDate <= '##Date2?2022-07-01##')
ORDER BY Id DESC

fork query

created jun 5 22 Martin20528