Appeals listing with identical start date appeals

[szabozoltan69]

Page URL

https://go.ifrc.org/

Environment

Production

Browser

Firefox

Steps to Reproduce the Issue

1. I checked the appeal list below "Active Operations Map"
2. While there was an identical start date for two rows, the 5th and 6th one, both the 1st and 2nd page showed the same (5th) operation and none the 6th.

Expected Behavior

1. I check the appeal list below "Active Operations Map"
2. While there is an identical start date for two rows, the 5th and 6th one, the 5th should be on 1st and the 6th on 2nd page showed.

Actual Behavior

The https://goadmin.ifrc.org/api/v2/appeal/?limit=5&offset=0&ordering=-start_date and
The https://goadmin.ifrc.org/api/v2/appeal/?limit=5&offset=5&ordering=-start_date query is not forced to use any other ordering entity, but the start date. In case of identical start date of 2 entities the query system can decide to have the same 2 entities in different order in the 1st and 2nd query, so an operation can disappear.

Priority

Medium (Affects functionality, but there is a workaround)

Additional Context (Optional)

The solution is easy. We should introduce a new ordering key besides -start_date, e.g. -id – just to be sure that the ordering is always the same, even in case of matching start dates of different entities.