Change all queries used in overview to sort results descending

A trading platform including ERP, CRM, and accounting

Brought to you by: danielmazurek, fleque, grmpf, jfirechief, and 2 others

#1124 Change all queries used in overview to sort results descending

Milestone: 1.2

Status: closed-fixed

Owner: nobody

Labels: JFireTrade (306)

Priority: 5

Updated: 2011-01-08

Created: 2010-10-21

Creator: jfirechief

Private: No

DO NOT EDIT OR ANSWER THIS ISSUE. SEE THE ORIGINAL ISSUE INSTEAD:
https://www.jfire.org/modules/bugs/view.php?id=1795
ORIGINAL REPORTER: alex

They should be sorted descending by the creation timestamp, so in every search result the newest one will be first.

More importantly, by doing this the results of the overview queries
with a range (or limit) will return the newest data-sets instead of
the last ones or a random order. A limit is set by default in the overview.

Please apply this to all queries used in the overview (Order, Offer, Invoice, Delivery).

Note that this is not about sorting the list in the client, it's about the client having the correct results...

Discussion

jfirechief - 2010-10-21

labels: --> JFireTrade

milestone: --> 1.2

status: open --> open-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

jfirechief - 2010-10-21

ORIGINAL COMMENT BY marco, VIEW IT HERE:
https://www.jfire.org/modules/bugs/view.php?id=1795

> They should be sorted descending by the appropriate id
> (offerID, InvoiceID etc) so in every search result the
> newest one will be first.

Sorry, but that's wrong (and does not work) because of the prefix. Since the prefix can be arbitrarily chosen (e.g. "myproject-xy"), we cannot use the identifiers for the sorting at all.

It is therefore necessary to instead order by the creation timestamp! I changed the description appropriately.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

jfirechief - 2010-10-21

ORIGINAL COMMENT BY fitas_java, VIEW IT HERE:
https://www.jfire.org/modules/bugs/view.php?id=1795

changed the query to return the first created article container, also in the table lists the results are displayed by descending order.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

jfirechief - 2011-01-08

status: open-fixed --> closed-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

jfirechief - 2011-01-08

ORIGINAL COMMENT BY marco, VIEW IT HERE:
https://www.jfire.org/modules/bugs/view.php?id=1795

> They should be sorted descending by the appropriate id
> (offerID, InvoiceID etc) so in every search result the
> newest one will be first.

Sorry, but that's wrong (and does not work) because of the prefix. Since the prefix can be arbitrarily chosen (e.g. "myproject-xy"), we cannot use the identifiers for the sorting at all.

It is therefore necessary to instead order by the creation timestamp! I changed the description appropriately.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

jfirechief - 2011-01-08

ORIGINAL COMMENT BY fitas_java, VIEW IT HERE:
https://www.jfire.org/modules/bugs/view.php?id=1795

changed the query to return the first created article container, also in the table lists the results are displayed by descending order.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

jfirechief - 2011-01-08

ORIGINAL COMMENT BY alex, VIEW IT HERE:
https://www.jfire.org/modules/bugs/view.php?id=1795

Review functionality: Works as described

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.