#977

Webhook Retries in the Metric

Operations needs to know how many different orders received events in webhook_events. Retries for the same order_id must not inflate the metric. Fix the report so it returns one value, n, for the number of unique orders.

Buggy query
SELECT COUNT(*) AS n FROM webhook_events;

Kampjun tal-output mistenni

Dan hu kif tidher tweġiba korretta — l-għadd tar-ringieli huwa tiegħu stess, m'għandux għalfejn jaqbel mat-tabelli tal-iskema.

n
2

Ir-riżultat tal-query tiegħek jidher hawn