search

ripple / rippled-historical-database

SQL database as a canonical source of historical data
97 stars 68 forks source link

/v2/accounts/{address}/transactions fails to return if descending=true #198

Open kolya182 opened 5 years ago

kolya182 commented 5 years ago

Docs https://github.com/ripple/rippled-historical-database#get-account-transaction-history

Excepted result: https://data.ripple.com/v2/accounts/rGig91TmYtssYz8umHGtF6A22gBtwgLxHn/transactions?type=Payment&result=tesSUCCESS&limit=1&descending=true to return transactions in descending order

Actual result: Server response code: 500 Internal Server Error

{
    "result": "error",
    "message": "unable to retrieve transactions"
}

Workarounds:

  1. Remove result=tesSUCCESS from query and sort manually" https://data.ripple.com/v2/accounts/rGig91TmYtssYz8umHGtF6A22gBtwgLxHn/transactions?type=Payment&limit=1&descending=true
  2. Remove sort criteria descending=true and sort manually: https://data.ripple.com/v2/accounts/rGig91TmYtssYz8umHGtF6A22gBtwgLxHn/transactions?type=Payment&result=tesSUCCESS&limit=1

@shekenahglory Can you take a look ?.

kolya182 commented 4 years ago

@mDuo13 Who is maintaining this repo ?