In my installation of 1.3.0.beta1, Badge that ‘Update daily’ won’t trigger automatically.
SELECT u.id AS user_id, MIN(u.created_at + interval '8 day') AS granted_at FROM users u JOIN posts p ON p.user_id = u.id WHERE u.id > 0 AND u.active AND NOT u.blocked AND u.created_at + interval '8 day' < now() AND p.deleted_at IS NULL AND NOT p.hidden AND p.created_at + interval '8 day' > now() AND (:backfill OR u.id IN (:user_ids)) GROUP BY u.id HAVING COUNT(p.id) > 0
but Preview granted badges | Preview with query plan are working normally.
Badge Query Preview
5 badges to be assigned.
… at Feb 21, 2015 8:44 am
… at Feb 21, 2015 12:03 am
… at Feb 20, 2015 9:03 pm
… at Feb 22, 2015 10:40 am
… at Feb 20, 2015 8:52 pm
Trigger: Update daily
Allow badge to be used as a title
Show badge on the public badges page