Order View (sort/order)
Order View (sort/order)
(OP)
Anyone having issues sorting / viewing most recent orders in Order View?
Environment:
Macola ES 9.5.800
Issue:
When attempting to view orders for a customer via Order View (OE & RMA - View - Orders/Invoices) the orders that are displayed on the page are not consistent. Attempts to sort by order number or date seems to only work for the current page and cannot "page up" to most recent as this will still only show the existing orders (makes sense from the query that gets submitted when page up is entered shown later but still wrong).
For example I attempt to view orders for a customer with a lot of orders (> 7450) so I go to OE & RMA - View - Orders/Invoices, type in a customer number and tab through to get the orders to list. The list that gets displayed may or may not be the most recent. If I escape and reenter the customer number and tab through again the list that is displayed may be or may not be the same as list I just saw and may or may not be the most recent.
When the list is not the most recent the Page Up button is available and when I click it the page does not change. The query behind the scenes that gets run is: select * from #oeinqtemp where id >= [someidnumberhere] where the idnumber appears random through each time of entering the view.
Note: it appears each page contains about 300 records.
Prior to this the queries that are run seem like everything should be good:
Create a temp table and fill it with all the orders (active & history) ordered by id
Running Procmon I don't find much of anything except at the point when the list is displayed FJMACEXE.EXE is looking for and cannot find macole.dll.dll
For kicks I copy macole.dll to macole.dll.dll this time in procmon FJMACEXE.EXE doesn't go looking for macole.dll.dll
This appears to be a bug however Exact support can't reproduce it so for them it is not a bug. I can reproduce it all day long for accounts with a lot of orders. I have not been able to reproduce so far with any account having less than 7450 orders.
Anyone else able to 1) reproduce 2) have a solution?
Thanks.
Environment:
Macola ES 9.5.800
Issue:
When attempting to view orders for a customer via Order View (OE & RMA - View - Orders/Invoices) the orders that are displayed on the page are not consistent. Attempts to sort by order number or date seems to only work for the current page and cannot "page up" to most recent as this will still only show the existing orders (makes sense from the query that gets submitted when page up is entered shown later but still wrong).
For example I attempt to view orders for a customer with a lot of orders (> 7450) so I go to OE & RMA - View - Orders/Invoices, type in a customer number and tab through to get the orders to list. The list that gets displayed may or may not be the most recent. If I escape and reenter the customer number and tab through again the list that is displayed may be or may not be the same as list I just saw and may or may not be the most recent.
When the list is not the most recent the Page Up button is available and when I click it the page does not change. The query behind the scenes that gets run is: select * from #oeinqtemp where id >= [someidnumberhere] where the idnumber appears random through each time of entering the view.
Note: it appears each page contains about 300 records.
Prior to this the queries that are run seem like everything should be good:
Create a temp table and fill it with all the orders (active & history) ordered by id
Running Procmon I don't find much of anything except at the point when the list is displayed FJMACEXE.EXE is looking for and cannot find macole.dll.dll
For kicks I copy macole.dll to macole.dll.dll this time in procmon FJMACEXE.EXE doesn't go looking for macole.dll.dll
This appears to be a bug however Exact support can't reproduce it so for them it is not a bug. I can reproduce it all day long for accounts with a lot of orders. I have not been able to reproduce so far with any account having less than 7450 orders.
Anyone else able to 1) reproduce 2) have a solution?
Thanks.
Talk To Other Members
RE: Order View (sort/order)