8

This question already has an answer here:

Specifying the user:<id> option to the search string allows you to search for posts written by specified user. That also includes the wiki posts, which are considered community owned (almost everyone could modify them). But I was surprised that searching by user doesn't work for deleted users, despite of the fact that user id is still visible on the user card:

deleted user

Could the searching for posts made by currently deleted user be possible? Is there a reason to don't allow it?

One possible usecase is when the user with a lot of useful posts decides to delete your account, and you will be able to search for they posts though.

marked as duplicate by Sonic the Anonymous Hedgehog, Community Jan 24 at 10:58

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • Oh ... somebody doesn't want this feature, but why? Too hard to implement? I see you lazy developer! – αλεχολυτ Jan 23 at 15:45
  • Somewhat tangential, but see also my argument on MSO that CW posts aren't community-owned. – Nathan Tuggy Jan 23 at 18:48
  • @SonictheIntrovertedHedgehog it seems that real reason to decline is posted in this comment: "none of that is pulled into the search index, and even that is partial string searching, not an efficient int match. – Nick Craver♦" – αλεχολυτ Jan 24 at 10:57
  • Your request doesn't bring in any new counter-arguments to the declining reason to implement this, and it's declined for technical reasons. – Sonic the Anonymous Hedgehog Jan 24 at 10:59
  • @SonictheIntrovertedHedgehog I no longer believe that I will hear on SE: "Yes, we need this feature, it is worth it to implement" ... "despite of our imperfect architecture" – αλεχολυτ Jan 24 at 11:06
9

Until this gets implemented you can use this SEDE Query

select p.id as [Post Link]
     , p.score
     , q.viewcount
     , p.creationdate
     , case p.posttypeid 
       when 1 then 
         concat('Question'
               , case 
                 when q.closeddate is not null then ' [closed]' 
                 else '' 
                 end)
       when 2 then
         concat('Answer' 
         , case 
           when q.acceptedanswerid = p.id then ' [accepted]' 
           else ''
           end
         )
       else '?' 
       end [Question/Answer]
from posts p
inner join posts q on q.id = coalesce(p.parentid, p.id) 
where p.ownerdisplayname = ##displayname:string?user218976##

When run today your result will look this:

sql result for posts based on displayname

SEDE is updated once a week, on Sunday around 03:00 UTC.

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