Server version 26.3.31.3254
Please assist me to understand why there is no condition available on the amount field in the where clause of an Advanced Query from the Transactions page.
You need to use the fields Debit or Credit
If I only need debit or only need credit transactions, I can use those fields. I appreciate that I can create conditions on Debit or Credit fields. But it does not satisfy all use cases. My example use case is to view all the transactions for a specific account in a specified amount range, e.g. between 20 000 and 100 000, debit and credit transactions in one query. Is there a practical reason why a condition on Amount is not supported.