Data ExplorerからのBadge Queryのテストに関する問題

[Mark_Schmucker (mark78)]

Data Explorer で任意のバッジクエリを実行できますか？

「Appreciated」を起点として、カスタムバッジクエリを作成したいと考えています。Data Explorer に Appreciated クエリを入力しました：

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

しかし、以下のエラーが発生します：

missing value for :backfill

「:」は効率を向上させる「バインド変数」であることを漠然と理解しています。backfill に関する部分を削除しようと試みましたが、別のエラーが発生しました。

[simon]

You will need to leave out the AND (:backfill OR p.user_id IN (:user_ids)) condition to run the query in the Data Explorer. :backfill and :user_ids both expect parameters to be passed to them.

[Mark_Schmucker (mark78)]

Thanks, it seems to work fine without the AND clause. Can you tell me what the clause does (assuming it gets the parameters passed in), so I can decide whether to keep it?

[simon]

@Mark_Schmucker

Can you tell me what the clause does (assuming it gets the parameters passed in), so I can decide whether to keep it?

If your badge is triggered by a user acting on a post, then you need to include this condition. The best description I’ve seen of how the :backfill and :user_ids parameters are used in badge queries is in the ‘Triggered badges have 2 extra constraints’ section of Create Triggered Custom Badge Queries.