From 91e6a43917622a91e1c6f69bfbf155ec63d87073 Mon Sep 17 00:00:00 2001 From: MS Date: Fri, 1 Sep 2023 13:54:23 +0200 Subject: Bank DB: getting the history query to return. --- sandbox/src/main/kotlin/tech/libeufin/sandbox/Database.kt | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sandbox/src/main/kotlin/tech/libeufin') diff --git a/sandbox/src/main/kotlin/tech/libeufin/sandbox/Database.kt b/sandbox/src/main/kotlin/tech/libeufin/sandbox/Database.kt index eab8d7f0..dde9d47b 100644 --- a/sandbox/src/main/kotlin/tech/libeufin/sandbox/Database.kt +++ b/sandbox/src/main/kotlin/tech/libeufin/sandbox/Database.kt @@ -329,7 +329,7 @@ class Database(private val dbConfig: String) { ,debtor_bic ,debtor_name ,subject - ,(amount).val AS amount_val, + ,(amount).val AS amount_val ,(amount).frac AS amount_frac ,transaction_date ,account_servicer_reference @@ -338,7 +338,7 @@ class Database(private val dbConfig: String) { ,direction ,bank_account_id FROM bank_account_transactions - WHERE bank_account_transaction_id < ? + WHERE bank_transaction_id < ? AND bank_account_id=? AND transaction_date BETWEEN ? AND ? """) -- cgit v1.2.3