Transaction listing appears out of order when created dates overlap

Created on 21 February 2023, over 2 years ago

Problem/Motivation

When using a balance transactor, the entity listing page at /transaction/{transaction_type}/{target_entity_type}/{target_entity_id} lists the transactions out of order which creates a confusing order of events.

Steps to reproduce

* Create several transactions with the same created timestamp (We did it via a migration from the userpoints module)
* View the transaction listing page for the target entity.

Proposed resolution

Add an "order by" to the listing page query to sort by the transaction ID as a tie-breaker.

Remaining tasks

Create patch.

🐛 Bug report

Status

Active

Version

1.0

Component

Code

Created by

🇺🇸United States merauluka

Live updates comments and jobs are added and updated live.

Comments & Activities

Issue created by @merauluka
@merauluka opened merge request.
Status changed to Closed: won't fix 3 months ago3:18pm 21 April 2025
Comment 3 months ago →
🇪🇸Spain manuel.adan 🌌
To ensure a proper transaction execution order the "execution_sequence" property must be set with a unique sequential number. The display order shouldn't relay on the ID since there may be more recent executed transactions than others not executed yet.

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024