Hey, So I’m trying to add another filter where if a user less than 2 days before a certain topic was created then they will be not included This is what I’ve tried. Relatively new with SQL so not sure how to go about this. Any help? SELECT * FROM topic t post_actions pa INNER JOIN users u ON u.id…

I’m still not sure I’m following what you’re after here, but if you know the post_id and the date you want to include new users from then maybe something like this? -- [params] -- int :post_id -- date :date SELECT pa.user_id, pa.created_at AS reltime$time FROM post_actions pa JOIN users u…

I’m not sure what you’re after with this one? Could you give us a little more detail about what you’re trying to achieve?

I’m trying to fix the date filter to filter out users made less than 2 days before a certain topic was created. I’ve been told either datediff or INTERVAL but havent got either to work. And I needed help with adding topic t as another inner join but I sorted that with: FROM post_actions pa INNER …

[image] Matt: t.id shows as a number rather than a preview is there anyway to go about that aswell? For this one you just need to alias t.id AS topic_id and it should work its magic for you. :+1: There are a few more examples of Explorer magic you can use in this topic - IDs in Data Explorer…

Yeah the same topic each time. So I think I’ve got it working with this. There was over 1000 results from this so I tried adding AND t.id = post.topic_id This shortened the list to 16 results but there were still 4 results of the same thing. Not sure how to fix that. SELECT t.id as topic_id,…

There are a few snags with that one, though I’m not swish enough with SQL to be able to explain them fully. :slightly_smiling_face: I think you wouldn’t need the topic_id if you already have the post_id, as the post id is unique to that post (and topic). You also seem to be trying to join the some …

[image] JammyDodger: I think you wouldn’t need the topic_id if you already have the post_id, as the post id is unique to that post (and topic). Yeah I know but whenever I remove the AND for the topic id the results go back up to 1000 for some reason. I’ll check out the link you sent. Hopefull…

I’ve managed to get it all working never known about reltime and I’ve implemented that into it. Thanks again for the help! One last question that’s regarding the reltime. is there a way to change the name from “time” to say “Topic created”?

Absolutely. :slightly_smiling_face: If you change it to reltime$topic_created that should do the trick. :+1:

Filter users likes out if account created x days prior to topic creation

Community Building Data & reporting

JammyDodger July 22, 2022, 1:48pm 10

Absolutely. If you change it to reltime$topic_created that should do the trick.

Topic		Replies	Views
Need help with a query: search by username instead of user_id Data & reporting sql-query	2	787	July 10, 2020
Topic list parameter for created after Feature	5	772	November 14, 2023
Data explorer query: find posts without replies Data & reporting sql-query	4	1016	February 15, 2021
Created a topic in a specific category with conditions Data & reporting sql-triggered-badge	0	208	December 26, 2022
Last 7 days of topics Product Support	8	844	April 14, 2018

Filter users likes out if account created x days prior to topic creation

Related topics