15

I can't do a "blame" for tag wikis. For example, in https://stackoverflow.com/tags/jquery/info , I can't see what edit added "which represents less than 28% of all browsers in use", and see if a vandal sneakily changed it from "2.8%" to "28%".

As there's 107 revisions I can't see any other way of checking what edit was responsible for content (though an "expand all" option might help).

10

If you are looking for a revision that is older than last sunday (that is when SEDE gets its refresh) you could use the following query ...

select creationdate
     , rev
     , userid as [User Link]
     , comment
     , text
from (
    -- first get all rows for a single post
    -- that reflect an edit
    -- to guarantee the revision nr is correct
    -- as it is dependant on the row_number
    select creationdate
         , row_number() over (order by creationdate asc) as rev
         , userid 
         , comment
         , text
    from posthistory
    where postid = ##postid:int?3607053## -- 3607053
    -- this works for wiki, for normal posts we need more magic
    -- because we have title and tag records as well
    and posthistorytypeid in (2, 5) -- initial body, edit body
) as main
where text like '%' + ##searchfor:String?represents less than 2##  + '%'

... to find the occurrences of the offending line of text.

You find the postid in the url of your browser when you click on the history link.

Do notice that the text column of the PostHistory table contains markdown so if the text you try find has markdown in it you need to use that in your search phrase as well.

You must log in to answer this question.

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