I would like to search for my username user122424 and a specific word used in comments that I remember from reading that comment to get back to it. How can I do that?
-
2$\begingroup$ To be clear it was a comment directed at you / about you. Not one you wrote? $\endgroup$– quid ModJul 11, 2020 at 18:59
-
1$\begingroup$ @quid Yes, a comment to my question and not written by me. $\endgroup$– user122424Jul 11, 2020 at 19:00
-
1$\begingroup$ I think you have to use SEDE or a datadump, likely somebody else will provide details. There is no way on-site. $\endgroup$– quid ModJul 11, 2020 at 19:07
-
$\begingroup$ @quid That's not good. What's SEDE ? Could possibly this feature be added to stackexchange site ? $\endgroup$– user122424Jul 11, 2020 at 19:09
-
$\begingroup$ @quid I have tried google but it hasn't found what I have remembered to be under my question in the comment. $\endgroup$– user122424Jul 11, 2020 at 19:12
-
2$\begingroup$ IIRC comments are not indexed by Google thus that's expected. SEDE means Stack Exchange Data Explorer. See the answer. // The feaure is unlikely to be added as comments are not considered as relevant. $\endgroup$– quid ModJul 11, 2020 at 19:24
-
$\begingroup$ @quid I somehow doubt that Google distinguishes between posts and comments in some major way - I guess the Google crawler simply checks what it sees on the page. (I agree that it would not surprise me if some comments might be missed by the crawler, especially in case when there is many comments. And certainly Google is rather suboptimal tool for searching comments.) Just to test is here are some Google searches which clearly find posts based on the comments dictatorship anarchy or ... $\endgroup$– Martin SleziakJul 11, 2020 at 19:41
-
$\begingroup$ ... proviso rubbish, in both cases searching on meta. (I hoped I would be able to find some notable comment or clever pun as an example. But since I wasn't able to recall something like that, I just tried with some random comments - but I chose such comments which contain some distinctive word.) $\endgroup$– Martin SleziakJul 11, 2020 at 19:42
-
1$\begingroup$ @MartinSleziak it seems I misunderstood something in the past. $\endgroup$– quid ModJul 11, 2020 at 20:00
1 Answer
Stack Exchange API have a function to return replies to specific user, so it is possible that you could somehow search among replies to you using this. But as I am not really familiar with using the API, I won't be able to suggest details of such method.
As mentioned in the comments, you could use the SEDE (Data Explorer). This was suggested also in older similar posts on this meta such as: Searching comments or How to browse or search comments?. You can also check some posts on Meta Stack Exchange, such as: How can I search for specific comments? pr Can I search my comments using some keyword(s)? (There are also a few feature requests about this: Ability to search comments would be useful or Add Ability To Search Comments Only. So if you think this would be a useful improvement, you can upvote those.)
Most likely interpretation of your question is that your looking for the words which contain both your username and also a phrase you're searching for. I will also include some other queries. Don't forget to switch to the site where you want to search (all linked queries are for the main site here on Mathematics). You can change the parameters to look for different phrases. (Parameters can be changed directly in the url or in the boxes below the query.)
- You can search for comments containing two different strings, such as 122424 and how. Notice that the query is case sensitive. Here is case insensitive version.
- You can also search for comments by a specific user containing the given string. Again, here is also a case insensitive version. (One of the parameters here is the userid of the user whose comments you want to see. Just in case, I'll include links to Help with what is my user id and how do I check it? and What is my user ID?)
- And one more query for comments containing the given word which were made under a post posted by a given user. (So in this case the userid is for the user who made the post, not the one of the commenter.) And here is a similar query, restricted just to the questions.
- Query searching for combination of the given two words only under posts by a specific user.
Maybe it is worth pointing out that the queries search for a given string which might be a part of a longer word. But you can include also a space as a part of the string you're searching for - so this might help in situation when matches for substring/superstring would cause a problem.
And I will include the usual caveat that the data in SEDE are only updated once a week.
Of course, you can create many other queries - limited basically just by the available data and possibilities of SQL. You can find several examples of such queries in the linked posts.
-
$\begingroup$ This would be OK for me, but it searches apparently only comments to me rather then comments from me and a possible word contained in some other comment. I guess so because all results begin with "@user122424: ". $\endgroup$ Jul 11, 2020 at 20:46
-
$\begingroup$ @user122424 The query you linked searches for two specific strings in comments by any user. Since one of the strings is 122424, it is only natural that typically those will be comments mentioning your username. If you use the same query with the parameters atom and poset, you can see that also one of your comments is among the results. $\endgroup$ Jul 11, 2020 at 21:13
-
$\begingroup$ Since you have mentioned that is was comment under your question, perhaps the third query could be useful for you. (The one which searches only among the comments under your posts.) $\endgroup$ Jul 11, 2020 at 21:40
-
$\begingroup$ You link doesn't work. I remember this was under my question: "[Since user122424 has 3000+ reputations this is not] {possible}" The words in [] may not be precisely as in that comment but the word in {} is exact as in the comment, I believe. The comment I'm searching for is from 6th or 7th month from the year 2020. $\endgroup$ Jul 12, 2020 at 17:09
-
$\begingroup$ @user122424 I don't really know where is the problem. To the best of my knowledge, this query should return all comments under your posts containing the string possible. Maybe the comment was deleted in the meantime? If the questions is not older than 60 days, you could check whether the question wasn't deleted under "deleted recent questions": Is there any way to see my deleted questions or answers?. $\endgroup$ Jul 12, 2020 at 17:33
-
$\begingroup$ @user122424 If you say that the comment was posted in the last two month, you could simply check the most recent comments on your posts - there probably aren't that many in that period. You can look at the in the responses tab of your profile page or you could use SEDE. $\endgroup$ Jul 12, 2020 at 18:11
-
$\begingroup$ Can I reach also comments of my deleted questions ? $\endgroup$ Jul 12, 2020 at 18:52
-
$\begingroup$ @user122424 Not through searching. But you can access you deleted questions (or answers) if you still have link to them somewhere. (As you probably know - after all, you've been on the site for quite a long time.) Still, there is some limited search for deleted posts that are at most 60 days old (and full search in your deleted posts at 10k+) - if you followed the link from my previous comment, you saw the details there. $\endgroup$ Jul 12, 2020 at 18:55
-
$\begingroup$ To include at least one example, you should be able to see this deleted question - since it is your question: Particular non-accessible category. It was posted on May 28 which is less than 60 days - so you should be able to find this question yourself using the "deleted recent question". (And once you reach 10k, then the no longer matters if you want to find your deleted posts.) $\endgroup$ Jul 12, 2020 at 18:59
-
$\begingroup$ Yes, I can access that question, but can I access also comments to it ? $\endgroup$ Jul 12, 2020 at 19:05
-
$\begingroup$ @user122424 It seems to me that we have digressed from the original question (which was about searching comments) quite a lot. Moreover, when reading some of your comments, it's a bit unclear to me what you're actually asking. Let me suggest that we continue in this chatroom (if needed) - chat is more suitable for longer exchanges. $\endgroup$ Jul 12, 2020 at 19:08