How do I get a list of all of my suggested edits across the stack exchange network?

On the stackexchange user panel e.g. https://stackexchange.com/users/4338618/mpag?tab=accounts, you CAN search all your Questions, Answers and comments, but there is no GET URI for seeing suggestion history like on the sub-sites (?tab=activity&sort=suggestions)




The following query on data.se allows for a user to see all accepted, rejected and pending suggested edits. As SE appears to uses MSSQL, this seems an appropriate forum.


I hope someone else finds it useful

Code paste:

-- My accepted/rejected/pending edits
-- Shows all my suggested edits
-- Returns all non-Meta StackExchange sites
-- Username searches are case-sensitive

 EXEC sp_MSforeachdb @precommand='CREATE TABLE ##fooj (Site nvarchar(150), [Site UserID] nvarchar(75), [Suggested Edit Link]  nvarchar(255), [Accepted?]  nvarchar(10), [Post Link]  nvarchar(75), comment  Text, [Creation Date]  DateTime, [Decision Date] DateTime)', 
 SELECT * from ##fooj order by [Creation Date] DESC
 DROP TABLE ##fooj
 @command1='USE [?] BEGIN 
IF (DB_Name() NOT IN (''master'', ''tempdb'', ''model'', ''msdb'') and DB_Name() NOT LIKE ''Meta.%'' and DB_Name() NOT LIKE ''%.Meta'') BEGIN 
With sn as (SELECT
PARSENAME(DB_Name(),1)+''.''+COALESCE(PARSENAME(DB_Name(),2),'''')+''.''+COALESCE(PARSENAME(DB_Name(),3),'''')+''.''+COALESCE(PARSENAME(DB_Name(),4),'''') aS SiteName
), sitesnames as (SELECT
LEFT(SiteName,LEN(SiteName)+1-patindex(''%[A-Za-z]%'', reverse(SiteName)) ) as SiteName
from sn
), sites as (SELECT
''https://''+SiteName+''.com/'' as SiteURL,
''https://''+SiteName+''.com/users/'' as UserBase,
''https://''+SiteName+''.com/a/'' as PostBase,
''https://''+SiteName+''.com/suggested-edits/'' as SugBase
from sitesnames
SELECT ''''+sites.SiteURL+''|''+sites.SiteName, --''''https://''+DB_Name()+''.com |''+DB_Name()+'''',
       ''''+sites.SugBase+CONVERT(NVARCHAR(250),e.id)+''|Suggestion #''+CONVERT(NVARCHAR(250),e.id)+'''' [Suggested Edit Link],
       CASE WhEN ApprovalDate>0 THEN ''Accepted'' WHEn RejectionDate>0 THEN ''Rejected'' ELSE ''Pending'' END as [Accept | Reject],
       ''''+sites.PostBase+CONVERT(NVARCHAR(250),e.PostId)+''|''+CONVERT(NVARCHAR(250),e.PostId)+'''' as [Post Link], 
       COALESCE(RejectionDate,e.ApprovalDate) as DecisionDate
       from sites CROSS JOIN ([?]..SuggestedEdits as e join [?]..Users as U on e.OwnerUserID = U.ID)
WHErE U.DisplayName=''##DisplayName##''
--order by COALESCE(e.RejectionDate,e.ApprovalDate) desc 
  • 2
    Not seems to, does. That's actually published info, and I believe the source code is probably open source, but don't quote me on that ... ;-) github.com/StackExchange/StackExchange.DataExplorer
    – jcolebrand Mod
    Nov 7 '17 at 18:19
  • note that there is a delay in the update of data queriable from data.stackexchange relative to what is made available to the actual user interface. It took a few days for one of my rejected revisions to make it into the list generated by this query.
    – mpag
    Nov 9 '17 at 21:31
  • 1
    I thought that was publicized on the site ... but I don't see it on data.stackexchange.com/help ... I've just been around the network way too long to remember what's tribal and what's written knowledge
    – jcolebrand Mod
    Nov 9 '17 at 22:28
  • the update delay is noted in the FAQ on that link: Frequently Asked Questions How often is the Stack Exchange Data Explorer updated? The data is updated early every Sunday morning around 3:00 UTC. The last update was Nov 5 at 7:12. that being said, I didn't bother looking at the help :P
    – mpag
    Nov 9 '17 at 22:51
  • My brain didn't see that hahahahaha
    – jcolebrand Mod
    Nov 9 '17 at 22:56

You must log in to answer this question.

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