12:09 PM
7 hours later…
7:05 PM
3
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 us...
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: ". — user122424 22 hours ago
@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. — Martin Sleziak 22 hours ago
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.) — Martin Sleziak 21 hours ago
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. — user122424 2 hours ago
@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?. — Martin Sleziak 2 hours ago
@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. — Martin Sleziak 54 mins ago
@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. — Martin Sleziak 11 mins ago
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.) — Martin Sleziak 6 mins ago
@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. — Martin Sleziak 12 secs ago
Yes. I have a problem I have asked some question which had comment below it in this sense "user122424 has 3000+ reputations so this seems possible" I'm not sure about the exact wording of the first part but I'm sure that there was the word "possible" I have visited all occurrences from your link, but none is the right one. I thought for a moment that that mine question has been deleted but this is also not the case. So I'm a bit confused where that question has gone.
@user122424 If you're entirely sure that the comment was posted on the main site and that it contained the word possible, this shows that either the comment was deleted, or the question was deleted. (Since it cannot be found through SEDE.)
But since you say that it was definitely in June or July, the easiest way to check whether such comment still exists on the main site is, in my opinion, to check your responses tab.
Maybe you might have luck in checking your global inbox, but I am not really sure whether the comments which were later deleted stay there.
Just in case: Does global inbox have a separate url and page? This should be the link to the global inbox: stackexchange.com/users/current?tab=inbox
7:29 PM
Yes, I have checked the first 12 pages of my comments from your link. There are in total 43 of them. But I'm also checked all results from your other link which searched for id 122424 and the word "possible". None is the right one. I believe that the word was not misspelled. Could you please create form me a link which searches through tex.stackexchange.com comments for the id 122424 and the word possible ? This is the only idea I have. I cannot create that link by myslef, I do n
But keep in mind that your user id on TeX - LaTeX is different from Mathematics. Do you use a the same username there?
7:36 PM
There instances of the word possible under your posts on TeX - LaTeX: data.stackexchange.com/tex/query/1261691/…
> 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)?
8:00 PM
8:11 PM
If you use the query without parameters it will use UserId=8297 and Word=chat: data.stackexchange.com/math/query/1261691/…
In the other words, I included 8297 as the default value of UserId - of course, it can be changed to other value as you have seen.
8:31 PM
Please, can you have a look at this and tell me how do I search for WordB being from the string CreationDate instead of from the text of the comment?
Like this:
AND (c.CreationDate >= '##Date1?2019-01-01##') AND (c.CreationDate <= '##Date2?2020-01-01##')
You can use
(c.CreationDate >= '##Date1##) AND (c.CreationDate <= ##Date2##)
and simply use Date1=2020-01-01 and Date2=20201-01-01.
Of course, you probably could somehow convert CreationDate to string and then use it as a string. But this seems to be a more natural way.
Probably I should add a disclaimer that I do not know much about SQL. I have only learned a bit while using Mathematics - which lead to looking at various SEDE queries.
« first day (2047 days earlier) ← previous day next day → last day (1395 days later) »