I have a few ideas for badges but I’m unsure how to write the queries (I don’t know the table structure well enough). The numbers are just to use as a base. I’ll be extending them for additional badges. Someone got 10 votes on a single topic they wrote Someone got 20 votes total between all topi…

[image] Marc_Montecalvo: Someone voted 20 times The second query in this topic might do the trick: Badge ideas for Topic Voting . The query grants the badge to users who have cast a single vote, but there is a suggestion at the bottom of the query for how to require more votes to grant the bad…

Thanks @simon . I actually read over that post already but the query didn’t return the results I was expecting. It was the Limit 1 at the end messing me up. After removing that it works perfect for the “Someone voted x times”. Any idea how to see how many votes a person got on a topic they wrote?…

[image] Marc_Montecalvo: Any idea how to see how many votes a person got on a topic they wrote? Or how many likes they got total? You might find some Data Explorer queries that you can modify to create badge queries. Have a look at the data explorer queries for topic voting and other sql-quer…

[image] Marc_Montecalvo: Anyone already have some badges like this and want to share? Aren’t these rather similar to badges that already exist in Discourse?

That got me quite a ways towards my target: select t.user_id, ucf.value, count(*) from topics t join user_custom_fields ucf on t.id = cast(ucf.value as int) where ucf.name = 'votes' group by ucf.value, t.user_id order by t.user_id, count(*) desc That returns: [image] The…

I think I got it! This will give the topic with the most votes per person that has at least 5 votes on it: WITH query as ( select t.user_id, ucf.value, count(*) as num, t.created_at, row_number() OVER (PARTITION BY t.user_id order by count(*) desc) as rank from topics t…

À la recherche de bons badges liés au vote

Communauté Données et rapports

simon Avril 26, 2019, 6:55 4

Vous pourriez trouver des requêtes Data Explorer que vous pouvez modifier pour créer des requêtes de badges. Consultez les requêtes Data Explorer pour les votes sur les sujets ainsi que les autres sujets sql-query et sql-triggered-badge.

Sujet		Réponses	Vues
Badge ideas for Topic Voting Feature badges , topic-voting , sql-triggered-badge	0	1851	Juin 24, 2016
Make a badge for the answer with the most likes in a topic! Data & reporting sql-triggered-badge	4	3352	Mars 29, 2016
Badge query for topic views Data & reporting sql-triggered-badge	4	589	Juin 25, 2022
Badges for reading [ :warning: intensive] Data & reporting sql-triggered-badge	5	276	Août 7, 2015
Badge for poll vote + topic post with min post likes? Data & reporting polls , sql-triggered-badge	0	182	Août 13, 2019

À la recherche de bons badges liés au vote

Sujets connexes