Problema al probar la consulta de insignias desde el Explorador de datos

Comunidad Datos e informes
1

¿Debería poder ejecutar cualquier consulta de insignia en el Explorador de datos?

Quiero crear una consulta de insignia personalizada utilizando “Apreciado” como punto de partida. Escribo la consulta de Apreciado en el Explorador de datos:

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

Esto genera un error:

valor faltante para :backfill

Entiendo vagamente que “:” es una “variable de enlace” que mejora la eficiencia. Intenté eliminar la parte sobre la retroalimentación, pero eso genera otro error.

2

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.

1 me gusta
3

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?

4

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.

3 Me gusta
6

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.