Skip to main content

All 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/...
M--'s user avatar
  • 2,027
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 ...
William Ledbetter's user avatar
-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 ...
stevec's user avatar
  • 1,245
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 ...
cocomac's user avatar
  • 14.3k
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 ...
user000001's user avatar
  • 4,058
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 ...
VHS's user avatar
  • 231
-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 = ...
WXJ96163's user avatar
  • 745
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 ...
rene's user avatar
  • 91.1k
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 ...
anirudh's user avatar
  • 153
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 ...
Aditya Narkar's user avatar
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 ...
shantanuo's user avatar
  • 529
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 ...
Avyansh Katiyar's user avatar
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, ...
JonathanDavidArndt's user avatar
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 ...
Zanna's user avatar
  • 3,057
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.
user avatar

15 30 50 per page