[FEATURE] Remove database query from queryTransaction.
[TEST] Add integration test for notifications endpoint.