Request:
curl 'https://***************/v1/payments?StartDate=2019-01-01&EndDate=2019-01-10&Offset=1' -H 'Accept: application/json, text/plain, */*' -H 'Referer: http://localhost:4200/dashboard/send-money-transaction-history' -H 'Origin: http://localhost:4200' -H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36' -H 'Authorization: Bearer *****************' -H 'Content-Type: application/json' --compressed

Response:
{ "Code": "400", "Error":"Bad Request", "Message":"{"timestamp":"2019-01-16T07:09:42.038+0000","status":500,"error":"Internal Server Error","message":"Access database using jOOQ; bad SQL grammar [select count(*) as \"c\" from (select \"transaction_journal\".\"id\", \"transaction_journal\".\"reference_number\", \"transaction_journal\".\"source_account_number\" as \"DebtorAccountId\", \"transaction_journal\".\"destination_account_number\" as \"CreditorAccountId\", \"transaction_journal\".\"amount\", \"transaction_journal\".\"service_fee\", \"currency\".\"currency_code\" as \"Currency\", \"transaction_journal\".\"transaction_date\", \"transaction_journal\".\"transfer_schedule_type\" as \"TransactionType\", \"send_money_type\".\"send_money_type_description\" as \"SendMoneyType\", \"transaction_journal\".\"status\" as \"TransferStatus\", \"transaction_journal\".\"remarks\" from \"transaction_journal\" left outer join \"send_money_type\" on \"transaction_journal\".\"send_money_type_id\" = \"send_money_type\".\"id\" left outer join \"currency\" on \"transaction_journal\".\"currency_id\" = \"currency\".\"id\" where (1 = 1 and 1 = 1 and (\"transaction_journal\".\"transaction_date\" >= cast(? as timestamp) or (\"future_dated_transaction\".\"recurring_start_date\" >= cast(? as timestamp) and \"future_dated_transaction\".\"recurring_end_date\" >= cast(? as timestamp))) and (\"transaction_journal\".\"transaction_date\" <= cast(? as timestamp) or (\"future_dated_transaction\".\"recurring_start_date\" <= cast(? as timestamp) and \"future_dated_transaction\".\"recurring_end_date\" <= cast(? as timestamp))) and 1 = 1 and \"transaction_journal\".\"user_id\" = ? and 1 = 1 and \"transaction_journal\".\"transfer_schedule_type\" in (?))) as \"q\"]; nested exception is org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table \"future_dated_transaction\"\n Position: 938","path":"/send-money"}" }