Add integration test for the transaction history endpoint returning entries in descending timestamp order

[Chucks1093]

Summary

The transaction history endpoint should always return entries newest-first regardless of the order they were inserted. An integration test should insert transactions out of chronological order and confirm the endpoint consistently returns them sorted descending by timestamp.

Scope

• Insert three transactions with timestamps: T+30s, T+10s, T+20s (intentionally out of order)
• Call the transaction history endpoint
• Assert the response order is T+30s, T+20s, T+10s
• Paginate to the second page and assert the sort order is maintained across pages
• Assert the created_at field in each entry matches the inserted timestamp

Acceptance Criteria

• Transactions returned newest-first regardless of insertion order
• Sort order maintained across paginated pages
• created_at in each entry matches the database timestamp
• Test fails if the ORDER BY clause is removed

ETA: 12 hours

---

Coordinate on Telegram

[Sensei-Victor]

I have experience with GitHub and code development, and I’ve reviewed the issue. I can work on it and submit a PR within 2 days.

[odiliflash-ops]

I would love to work on this issue, i have Software Engineering experience and good problem solving skills

[OmniZlatoon]

@OmniZlatoon has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Good day sir, Ready to deliver the task A.S.A.P. Gone through the issue and to be honest, i can work the task with the right tools at hand. please assign me maintainer . My eta is 5 hours

ℹ️ Repo Maintainers: To accept this application, review their application or assign @OmniZlatoon to this issue.

[Opulencechuks]

@Opulencechuks has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

I am confident that I can implement this issue having worked on something similar in the past

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Opulencechuks to this issue.

[bright5455]

@bright5455 has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hello maintainers

I have read and understood the issue
I can deliver in an hour
I can work on this issue perfectly
Please kindly assign it to me

Thank you

ℹ️ Repo Maintainers: To accept this application, review their application or assign @bright5455 to this issue.

[somotochukwu-dev]

@somotochukwu-dev has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Please assign this issue to me
Thanks

ℹ️ Repo Maintainers: To accept this application, review their application or assign @somotochukwu-dev to this issue.

[oscar24357]

@oscar24357 has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

hello boss, good evening, can you please assign this issue to me

ℹ️ Repo Maintainers: To accept this application, review their application or assign @oscar24357 to this issue.

[flexocode442]

@flexocode442 has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

‎Hi, I'd like to work on this issue. I've gone through the description and acceptance criteria and I'm confident I can deliver it. I'll make sure every acceptance criterion is met and submit a clean, tested PR. Please assign it to me.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @flexocode442 to this issue.

[kingbitnation]

@kingbitnation has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

I'd like to work on this issue. I've reviewed the requirements and have a clear implementation plan. If assigned, I'll submit a high-quality PR that follows the project's guidelines.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @kingbitnation to this issue.

[CeceOs92]

@CeceOs92 has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

kindly assign me this

ℹ️ Repo Maintainers: To accept this application, review their application or assign @CeceOs92 to this issue.

[drips-wave]

Congratulations, @CeceOs92! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on July 30, 2026.

🧑‍💻 @CeceOs92: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊