All Questions
20
questions
5
votes
2
answers
249
views
Search for comments on posts with a certain tag based on a keyword
I am trying to get the comments on posts with a specific tag which include a phrase or a keyword of interest using SEDE. Here's my first attempt: https://data.stackexchange.com/stackoverflow/query/...
9
votes
1
answer
215
views
When were comments first available on Stack Exchange?
I am curious about when comments first became available on Stack Exchange (or whatever the site was when the development occurred). I ask this because, in the Database schema documentation for the ...
-2
votes
1
answer
173
views
How can you view the most upvoted comments on your posts (answers and questions)?
Is there a way to view the most upvoted comments from any of my answers or questions on Stack Overflow?
There are two similar questions/answers:
Search for my most upvoted comments and
Can I view a ...
18
votes
3
answers
455
views
Is flagging a bunch of "thanks" comments OK?
I made a SEDE query to find all the comments that contained thank, the @ character, weren't saying yes/no to something, and were less than 20 characters. The query is here. It returned over 1400 ...
7
votes
1
answer
146
views
Most upvoted comments across Stack Exchange (Cross site query)
I was interested in finding out the most upvoted comments per user across the entire Stack Exchange network (cross-site query).
I found this query, which works very well, but only for one site at a ...
7
votes
1
answer
87
views
Which data dump has the information related to mentioned users in a comment
From the Stack Exchange API, I can retrieve the comments in which a specific user is mentioned using @ method.
Here is the /users/{ids}/mentioned API.
Which data dump on archive.org hosts this ...
-2
votes
1
answer
138
views
How to use stackexchange query correctly?
I am trying to find one piece of comments by someone else on my post("that I continue to learn and grow", does this expression sound natural?), following another meta post.
with userid = ...
29
votes
1
answer
563
views
How many posts are downvoted without a comment?
A returning theme on our beautiful and productive Meta sites is the topic on downvoting without leaving a comment. Yes, that is a bit cheeky and admit it: you've done that as well.
In a recent post ...
5
votes
2
answers
78
views
Merge Comments on Data Explorer
I'm trying to get StackOverflow posts along with comments. However it returns each post with the individual comments as a separate record. Something like this -
ID Post Comment1
ID Post Comment2
ID ...
2
votes
1
answer
132
views
VoteTypeIds in the context of Comments for StackOverflow Posts
Known information:
As per this answer comments can't be downvoted.
VoteTypeId 3 means downvote on a given post. referred answer
My Assumption: Comments should not be downvoted and therefore Votes ...
5
votes
0
answers
169
views
List all comments upvoted by me [duplicate]
I can see all my upvotes in the "votes" tab of my user page. For example,
https://stackoverflow.com/users/139150/shantanuo?tab=votes
This includes the questions, answers and comments. Is there a way ...
4
votes
1
answer
79
views
Query for maximum number of comments by a user on a post
Does a query exist in the Data Explorer which lets you know the maximum number of comments by a user on a question? I've not been able to find one; the closest query I was able to find was Number of ...
5
votes
1
answer
1k
views
Is there any way to view comment flags in the Data Explorer?
Using the Data Explorer (SEDE), is there any way to view the flags on individual comments?
After reading this post, it appears there is plenty of information in the tables FlagTypes, PendingFlags, ...
4
votes
0
answers
45
views
How can I easily access the markdown text of a comment? [duplicate]
So the query in the answer to the question this has been closed against has exactly the same problem as the query I mentioned in my question - I can't actually see more than the first few words of the ...
3
votes
1
answer
43
views
UserDisplayName column is empty in the Comments table
The column UserDisplayName of the Comments table in Data Explorer appears to be empty.
Demonstration.