commit 620933fb685e1a66f27c619bdd519cd7134b8230 parent 672a7b0fe66f36c0dbcbd135b5e2808a1c6ac4b2 Author: Christian Grothoff <christian@grothoff.org> Date: Mon, 1 Apr 2024 21:18:47 +0200 -filter by *effective* refunds Diffstat:
| M | src/backenddb/pg_lookup_deposits_by_contract_and_coin.c | | | 4 | ++++ |
1 file 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 @@ -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"