A more complete set of requirements for this, given a page size of N:
All query_* APIs must return records in a consistent sort order, no matter the query parameters provided
Different ordering will need to be done independently of the query parameters
Some work has already been done on this in https://github.com/h-REA/hREA/tree/feature/220-ordered-query-apis however it seems there are a few data architecture concerns to work through. Still figuring out the specifics, will split out additional issues if it turns out this is more involved than previously expected.
A more complete set of requirements for this, given a page size of N:
query_*APIs must return records in a consistent sort order, no matter the query parameters providedSome work has already been done on this in https://github.com/h-REA/hREA/tree/feature/220-ordered-query-apis however it seems there are a few data architecture concerns to work through. Still figuring out the specifics, will split out additional issues if it turns out this is more involved than previously expected.