I have seen that this badge exists for users who visit the forum consecutively for 10 or 365 days, but I want to create an automatic badge in my forum that is awarded to a person who visited the forum for 30 consecutive days. Above all, what I’m interested in is getting the SQL. [صورة]

FWIW, you can find the existing queries using the Data Explorer . e.g: SELECT * from badges WHERE query LIKE '%10 days%' Here’s the one for 365 days: WITH consecutive_visits AS ( SELECT user_id , visited_at , visited_at - (DENSE_RANK() OVER (PARTITION BY user_id ORDER BY visited_at))::int s FROM u…

Thank you very much, I appreciate it. [صورة]

@merefield [Captura Query] I’ve been trying to copy the code, but it’s like blocked, thanks again. :heart:

Stuck? How do you mean? (Please forgive my poor Spanish) I’ve just checked and it works fine. Check you have entered all the required fields and there are no validation errors above. If it Saves, you should see the new badge at the bottom of the list on the left. You can also preview the results…

I was trying in my forum to copy the SQL from the bagde referring to the 10 days and then change to 30, but it won’t let me copy it, but thanks to your help I was able to make the badge I wanted.

شعار زائر لمدة 30 يومًا

دعم المنتج

PaulinaMX (ForosMX) 9 أغسطس 2020، 8:07م 4

@merefield

لقد كنت أحاول نسخ الكود، لكنه يبدو وكأنه محظور. شكرًا لك مجددًا.

الموضوع		الردود	مرات العرض
Checking badge eligibility Data & reporting sql-query	3	561	16 يونيو 2020
'Seen in last X days' badge? Data & reporting sql-triggered-badge	12	348	26 أغسطس 2016
Should be enjoying Christmas! badge Data & reporting sql-triggered-badge	2	174	20 أبريل 2019
How can I see how many days in a row I visited the forum? Product Support	2	1813	25 أكتوبر 2018
Badge for total posts, and attendence Data & reporting sql-triggered-badge	2	207	7 أغسطس 2015

شعار زائر لمدة 30 يومًا

الموضوعات ذات الصلة