summaryrefslogtreecommitdiff
path: root/bank/src/main/kotlin/tech/libeufin/bank/db/TanDAO.kt
diff options
context:
space:
mode:
Diffstat (limited to 'bank/src/main/kotlin/tech/libeufin/bank/db/TanDAO.kt')
-rw-r--r--bank/src/main/kotlin/tech/libeufin/bank/db/TanDAO.kt2
1 files changed, 1 insertions, 1 deletions
diff --git a/bank/src/main/kotlin/tech/libeufin/bank/db/TanDAO.kt b/bank/src/main/kotlin/tech/libeufin/bank/db/TanDAO.kt
index 9017540d..66771c93 100644
--- a/bank/src/main/kotlin/tech/libeufin/bank/db/TanDAO.kt
+++ b/bank/src/main/kotlin/tech/libeufin/bank/db/TanDAO.kt
@@ -163,7 +163,7 @@ class TanDAO(private val db: Database) {
SELECT body, tan_challenges.tan_channel, tan_info
FROM tan_challenges
JOIN customers ON customer=customer_id
- WHERE challenge_id=? AND op=?::op_enum AND login=?
+ WHERE challenge_id=? AND op=?::op_enum AND login=? AND deleted_at IS NULL
""")
stmt.setLong(1, id)
stmt.setString(2, op.name)