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

[Bild] 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 p…

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: [Bild] Create Triggered Custom Badge Queries Badge triggers is a complex subject often “daily” updates suffice and all this complex stuff can be skipped.

Was ist das 'backfill'?

Gemeinschaft Daten & Berichterstattung

JammyDodger 26. August 2023 um 22:03 4

Ich denke, ich muss untersuchen, welche Badge-Abfragen dies tatsächlich erfordern. Ich glaube, wenn Sie Update Daily verwenden, ist dies nicht notwendig:

Thema		Antworten	Aufrufe
Problem testing Badge Query from Data Explorer Data & reporting sql-triggered-badge	4	1036	24. Mai 2019
Need some Help with my Triggered Custom Badge Query Support sql-triggered-badge	4	60	7. März 2026
Badge Backfill Code Feature	0	461	23. Dezember 2020
Creating triggered custom badge queries Site Management badges , how-to , sql-triggered-badge	0	12802	27. August 2014
SQL Querying in Badges Data & reporting sql-triggered-badge	2	1047	8. Juni 2024

Was ist das 'backfill'?

Verwandte Themen