- I want to search questions answered by me and some another user. How can I do this? I don't see an "and" operator.
- Is there a way to search through comments (answers under which there is some comment text)?
-
For 1., this answer may work. For 2., see How can I search for specific comments?– Glorfindel ModJan 23 at 18:15
-
For #1, do you want to find questions answered by you and at least one other user? Or do you want questions answered by you and a specific other user?– cocomacJan 23 at 18:20
-
@cocomac Specific.– oleeddJan 23 at 18:21
-
1@oleedd I'm not sure how off the top of my head, but it's likely possible using SEDE. I don't know exactly what the SQL needed would be, but I'd guess it is possible– cocomacJan 23 at 18:23
-
@Glorfindel 1. Unfortunately, it doesn't work (if I do correctly). 2. I know how to search in Google) I mean the direct search. Maybe something new since 2009...– oleeddJan 23 at 18:31
-
1@oleedd: To search comments, you can use this data explorer query– HimanshuJan 24 at 8:40
Add a comment
|
1 Answer
I want to search questions answered by me and some another user. How to do this? I don't see an "and" operator.
This is not possible via normal search, so you have to resort to tools like the Stack Exchange Data Explorer. With a bit of SQL, you can write queries like this one; you can change the user IDs and the site you want to search on:
answered Jan 23 at 18:41
-
-
-
Nicknames are not unique, and it would make the query slower (two extra joins), so that's bad practice. And it's unfortunately not possible with regular search ...– Glorfindel ModJan 23 at 20:27
-
I want to try with nicknames. How to modify? Ideal variant: id or nickname. Possible?– oleeddJan 23 at 20:39
-
You'll need to join both
Poststables withUsers(not unlike this page in the awesome tutorial and filter onDisplayName.– Glorfindel ModJan 23 at 20:40 -
I don't know
sqland can't do this. Can you make it work with both id's and nicknames?– oleeddJan 23 at 20:45 -
I could, but as I said, it's bad practice, so it would reduce the quality of my answer.– Glorfindel ModJan 23 at 20:46
-
I think I will accept it after that. For now, I have to get id's to use it, not handy.– oleeddJan 23 at 20:50
-
-
so it would reduce the quality of my answer — you can make a new query for this (no any reducing).– oleeddJan 23 at 21:04
-
It shows duplicates if another user or/and I have more than 1 answer (more answers, more duplicates). Is it fixable?– oleeddJan 23 at 23:12
-
-
Please make a new query for nicknames. You can give it in a comment if you don't want to change the answer.– oleeddJan 24 at 9:32