# 信任等级 0 + 自定义字段徽章

**URL:** https://meta.discourse.org/t/trust-level-0-custom-field-badge/179598
**Category:** Data & reporting
**Tags:** sql-triggered-badge
**Created:** [2021年二月13日 19:49 UTC](https://meta.discourse.org/t/trust-level-0-custom-field-badge/179598 "2021-02-13T19:49:26Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![cosdesign](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cosdesign/32/208585_2.png) [@cosdesign](https://meta.discourse.org/u/cosdesign)
#### Post date: [2021年二月20日 11:19 UTC](https://meta.discourse.org/t/trust-level-0-custom-field-badge/179598/2 "2021-02-20T11:19:06Z")

</div>

自定义字段现在可以工作了（[我尝试实现这个示例](https://meta.discourse.org/t/badges-based-on-user-custom-fields/276719/4?u=cosdesign)），但无论我输入什么信任等级，潜在用户数量都保持不变：

```
    SELECT cf.user_id user_id, cf.updated_at granted_at
    FROM user_custom_fields cf
    INNER JOIN user_fields uf
      ON uf.id = (0 || regexp_replace(cf.name, 'user_field_', ''))::integer
      AND uf.name = 'Gender'
    WHERE cf.value = 'Woman'
AND EXISTS (
  SELECT u.id user_id, current_timestamp granted_at FROM users u
    WHERE trust_level >= 0 AND (
  :backfill OR u.id IN (:user_ids)
    )
)

```

 ![image](https://global.discourse-cdn.com/meta/original/3X/2/d/2d3575074620a51f1bece085664716fbf65b2446.png)

有什么想法吗？

---

_[View the full topic](https://meta.discourse.org/t/trust-level-0-custom-field-badge/179598)._