diff options
author | MS <ms@taler.net> | 2023-09-01 13:54:23 +0200 |
---|---|---|
committer | MS <ms@taler.net> | 2023-09-01 13:54:23 +0200 |
commit | 91e6a43917622a91e1c6f69bfbf155ec63d87073 (patch) | |
tree | c8a2fa34b46a9c58fcd593abf602d8558871bf69 /sandbox/src/main/kotlin/tech/libeufin | |
parent | 71d67b8834e9b886f139d8ff35f43433bceec0df (diff) | |
download | libeufin-91e6a43917622a91e1c6f69bfbf155ec63d87073.tar.gz libeufin-91e6a43917622a91e1c6f69bfbf155ec63d87073.tar.bz2 libeufin-91e6a43917622a91e1c6f69bfbf155ec63d87073.zip |
Bank DB: getting the history query to return.
Diffstat (limited to 'sandbox/src/main/kotlin/tech/libeufin')
-rw-r--r-- | sandbox/src/main/kotlin/tech/libeufin/sandbox/Database.kt | 4 |
1 files changed, 2 insertions, 2 deletions
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 ? """) |