Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Change order results in SelectProduct.php
07-19-2012, 11:55 PM, (This post was last modified: 07-19-2012, 11:59 PM by PakRicard.)
#1
Change order results in SelectProduct.php
Hi all:

Does it make sense to change the order of the results in SelectProduct.php to

ORDER BY stockmaster.discontinued, stockmaster.stockid instead of current ORDER BY stockmaster.stockid?

It will return the current items (not discontinued) results first and then the obsolete (discontinued) ones. Most probably users are searching current items not obsolete ones, so chances are this order will make searches more efficient.

If it's acceptable for the community I'll code it...
Regards,
Pak Ricard
Reply
07-21-2012, 01:47 PM,
#2
RE: Change order results in SelectProduct.php
Coded and commited today.
Regards,
Pak Ricard
Reply
07-21-2012, 02:45 PM,
#3
RE: Change order results in SelectProduct.php
Nice thanks....
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)