diff options
| author | Christian Grothoff <christian@grothoff.org> | 2024-04-01 21:18:47 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2024-04-01 21:18:47 +0200 |
| commit | 620933fb685e1a66f27c619bdd519cd7134b8230 (patch) | |
| tree | c6c351b63f6f5825de12943a7a92abeb96321949 | |
| parent | 672a7b0fe66f36c0dbcbd135b5e2808a1c6ac4b2 (diff) | |
-filter by *effective* refunds
| -rw-r--r-- | src/backenddb/pg_lookup_deposits_by_contract_and_coin.c | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/backenddb/pg_lookup_deposits_by_contract_and_coin.c b/src/backenddb/pg_lookup_deposits_by_contract_and_coin.c index 294ca39c..089543ea 100644 --- a/src/backenddb/pg_lookup_deposits_by_contract_and_coin.c +++ b/src/backenddb/pg_lookup_deposits_by_contract_and_coin.c @@ -266,6 +266,10 @@ TMH_PG_lookup_deposits_by_contract_and_coin ( "SELECT" " refund_amount" " FROM merchant_refunds" + /* Join to filter by refunds that actually + did work, not only those we approved */ + " JOIN merchant_refund_proofs" + " USING (refund_serial)" " WHERE coin_pub=$3" " AND order_serial=" " (SELECT order_serial" |