Almost.
SELECT cf.user_id user_id, cf.updated_at granted_at
FROM user_custom_fields cf u
WHERE cf.name = 'user_field_1'
AND (
cf.user_id IN (:user_ids)
OR :backfill
)
AND length(cf.value) > 1
Almost.
SELECT cf.user_id user_id, cf.updated_at granted_at
FROM user_custom_fields cf u
WHERE cf.name = 'user_field_1'
AND (
cf.user_id IN (:user_ids)
OR :backfill
)
AND length(cf.value) > 1