commit 7e95a2a4021692f3e094c6f1997f1e543ce4a542
parent 316caf6036badf6a4fa2d16928648ad304ed866c
Author: Christian Grothoff <christian@grothoff.org>
Date: Thu, 3 Jul 2025 17:31:26 +0200
fix missing 2nd SQL statement update
Diffstat:
1 file changed, 3 insertions(+), 0 deletions(-)
diff --git a/src/exchangedb/pg_select_aml_decisions.c b/src/exchangedb/pg_select_aml_decisions.c
@@ -227,9 +227,12 @@ TEH_PG_select_aml_decisions (
",lo.is_active"
",lo.jnew_rules"
",kt.is_wallet"
+ ",wt.payto_uri"
" FROM legitimization_outcomes lo"
" JOIN kyc_targets kt"
" ON (lo.h_payto = kt.h_normalized_payto)"
+ " JOIN wire_targets wt"
+ " ON (lo.h_payto = wt.h_normalized_payto)"
" LEFT JOIN aml_history ah"
" USING (outcome_serial_id)"
" WHERE lo.outcome_serial_id < $7"