« first day (548 days earlier)      last day (1551 days later) » 

Feeds
Feeds
10:45 AM
0
Q: How to receive from SEDE the full timeline of a user profile?

NathalieFrom here is it possible to see the full and detailed actions of timeline. Example: number upvotes, question or answer link/id time received etc? How is it possible to receive it from SEDE?

discussion data-explorer
 
 
5 hours later…
Jeff Schaller
Jeff Schaller
3:21 PM
Is it possible to get a row number / sequence number added to the SEDE results? So when they're sorted, rows are numbered 1,2,3,etc?
 
Martin
Martin
@JeffSchaller There is also RANK() OVER(ORDER BY ... ). For example, this query.
StackOverflow post about the difference: SQL RANK() versus ROW_NUMBER().
 
Jeff Schaller
Jeff Schaller
@Martin perfect; thank you! I'm not a DBA, so I'm really hacking at the SQL. Also found data.stackexchange.com/unix/query/82456/sql-server-row-number, but I think my actual problem was that I didn't name my tables, so I kept "running out of resources"
hrmph. I don't know enough SQL :(
If I wanted to select users that do not have the Informed badge, what's the right incantation? I tried SELECT ... from Users LEFT OUTER JOIN badges on b.userid = u.id and b.name = 'Informed' ... but I'm getting users in the results that do have the Informed badge
 
Martin
Martin
3:47 PM
I have tried something here: Oldest accounts without Informed badge.
There are many users who know much more about SQL than I do - perhaps somebody will notice your question and suggest a better query.
 
Jeff Schaller
Jeff Schaller
That looks good, actually! I'm surprised by some of the results, but have confirmed that they are correct
Using a "NOT IN (...)" is smart -- thank you, @Martin!
 
 
3 hours later…
Feeds
Feeds
7:19 PM
-1
Q: Error in adding a new column to query

NathalieUsing this query, I would like to add a new column with user id I try this ;with postvotes as ( select v.creationdate, , p.id postid , case v.votetypeid when 1 then 'accepts' when 2 then 'up-votes' when 3 then 'down-votes' ...

discussion support data-explorer
 

« first day (548 days earlier)      last day (1551 days later) »