I’m not fully grasping the backfill condition so I am going get Lola Bot to explain. :grin:

[imagen] Create Triggered Custom Badge Queries The following badge is triggered on “when a user acts on a post”, this means “delta” applications will get the :post_ids parameter. SELECT p.user_id, p.id post_id, p.updated_at granted_at FROM badge_posts p WHERE p.like_count >= 25 AND (:backfill OR…

Yea it totally makes sense to me now. I think I prefer Sam’s explanation. Can you explain backfill condition a little bit more Lola?

I think I need to look into which badge queries actually need it adding. I think if you’re using `Update Daily’ it’s not necessary: [imagen] Create Triggered Custom Badge Queries Badge triggers is a complex subject often “daily” updates suffice and all this complex stuff can be skipped.

¿Qué es el 'backfill'?

Comunidad Datos e informes

JammyDodger 26 Agosto, 2023 22:03 4

Creo que necesito investigar qué consultas de insignias realmente necesitan que se agregue. Creo que si estás usando Update Daily, no es necesario:

Tema		Respuestas	Vistas
Problem testing Badge Query from Data Explorer Data & reporting sql-triggered-badge	4	1036	24 Mayo 2019
Need some Help with my Triggered Custom Badge Query Support sql-triggered-badge	4	60	7 Marzo 2026
Badge Backfill Code Feature	0	461	23 Diciembre 2020
Creating triggered custom badge queries Site Management badges , how-to , sql-triggered-badge	0	12811	27 Agosto 2014
SQL Querying in Badges Data & reporting sql-triggered-badge	2	1047	8 Junio 2024

¿Qué es el 'backfill'?

Temas relacionados