Should I be able to run any Badge Query in Data Explorer?
I want to create a custom Badge Query using “Appreciated” as a starting point. I type the Appreciated query in Data Explorer:
SELECT p.user_id, current_timestamp AS granted_at FROM posts AS p WHERE p.like_count >= 1 AND (:backfill OR p.user_id IN (:user_ids)) GROUP by p.user_id HAVING count(*) > 20
This gives an error:
missing value for :backfill
I vaguely understand that the “:” is a “bind variable” which improves efficiency. I tried removing the bit about backfill but that gives another error.