All Questions
20
questions
1
vote
0
answers
95
views
What am I supposed to do when I get what is probably the "requires external JavaScript" error for the chat domains and SEDE?
I'm suddenly getting this error in my main sites (like SO and MSE)
Meta Stack Exchange requires external JavaScript from another domain, which is blocked or failed to load. Retry using another source....
2
votes
1
answer
66
views
Search a SO post that I closed with a certain keyword
Is there a way to search for a Stack Overflow post that I closed and that has a certain keyword say "this" or certain code say this in it?
I mean, I want to search by typing in the search ...
5
votes
0
answers
130
views
Is there a data dump for SE chat logs?
I am working on a research project looking at Stackexchange posts. I am aware of the data explorer as well as the data dump stored on the internet archive. I was wondering if there was any information ...
6
votes
1
answer
235
views
How can I query users with a specific Job title?
I'm looking for a query which can be used to search a user by their title. I have tried looking into the Users table but the Job title/position column isn't present there.
It's the one highlighted ...
6
votes
0
answers
99
views
Why can't I sort SEDE results for some queries?
I was just checking out who earned the most of the new badges that were announced this week. I have a SEDE query for this which sorts by default on the number of sites you earned a badge. I noticed ...
6
votes
2
answers
140
views
How to distinguish audits from real reviews in SEDE data?
I was trying to look at some statistics on review outcomes using SEDE, but hit upon a snag: apparently, the SEDE ReviewTasks table also includes audit tasks, and there doesn't seem to be any way to ...
7
votes
2
answers
90
views
Read-only SE Data Explorer
I just learned about the Stack Exchange Data Explorer, and I'm really excited to explore the data! I was wondering, is there a way to get an authenticated, read-only connection to the database? I don'...
1
vote
0
answers
72
views
SEDE Extend graph support
I created this query which counts the number of post in a certain timeperiod for given tags. The result is pivoted.
I would like the graphing support to be extended to support pivoted-results of the ...
1
vote
0
answers
22
views
The graph label goes off the page
I was experimenting with some complex queries, and I'm having an issue with the graph. Not only is the label falling off the page (it continues for several page lengths past the graph), I cannot see ...
4
votes
1
answer
77
views
SEDE - is there a helper table with date records
I created several queries and needed some records with dates to join against.
For example:
CREATE TABLE #YearQuarter (Y int,
,MonthStart smalldatetime NULL
,MonthEnd smalldatetime NULL
...
11
votes
2
answers
242
views
Finding Number of Followers of a Tag in the Data Dump
I'm doing a research on the developers' QAs in Stack Overflow, I have checked Stack Exchange Data Explorer and data dumps but I didn't find number of followers of a tag:
There isn't any related ...
-14
votes
1
answer
272
views
How to get votes cast by a user
I want to query the upvotes and downvotes that have been cast by a person. Is there an API call for that? (I don't see one on the API docs.)
If there isn't a call for that, could this be achieved ...
18
votes
2
answers
263
views
Can we have functions in SEDE?
I want to define a function for use in an SQL query. But:
CREATE FUNCTION permission denied in database 'StackExchange.French'.
Is there a workaround that would allow me to do what I'm trying to do, ...
4
votes
0
answers
99
views
Add the full time to CreationDate column in Votes table in Data Explorer [duplicate]
I was trying out some queries in Data Explorer and noticed that, column CreationDate in table Votes doesn't contain the full timestamp. Only the date part is present and time part is set to 00:00:00.
...
13
votes
1
answer
124
views
Get favorite count for tag
Is there a way to get the number of times a tag is favorited or the favorite tags for a user in Data Explorer?
It seems Tags.Count is the total number of questions with that tag.
Count won't work ...