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

[이미지] Creating 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: [이미지] Creating triggered custom badge queries Badge triggers is a complex subject often “daily” updates suffice and all this complex stuff can be skipped.

‘backfill` 이란 무엇인가요?

커뮤니티 구축 데이터 및 보고

JammyDodger 8월 26, 2023, 10:03오후 4

어떤 배지 쿼리에 실제로 추가가 필요한지 조사해 봐야 할 것 같습니다. Update Daily를 사용하는 경우에는 필요하지 않을 것 같네요:

글		댓글	조회수
Problem testing Badge Query from Data Explorer Data & reporting sql-triggered-badge	3	1125	5월 24, 2019
Need some Help with my Triggered Custom Badge Query Product Support sql-triggered-badge	3	178	2월 5, 2026
Badge Backfill Code Feature	0	509	12월 23, 2020
Creating triggered custom badge queries Site Management badges , how-to , sql-triggered-badge	0	13181	8월 27, 2014
SQL Querying in Badges Data & reporting sql-triggered-badge	1	1102	12월 4, 2015

‘backfill` 이란 무엇인가요?

Related topics