Post Reply 
 
Thread Rating:
  • 0 Votes - 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.)
Post: #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
Find all posts by this user
Quote this message in a reply
07-21-2012, 01:47 PM
Post: #2
RE: Change order results in SelectProduct.php
Coded and commited today.

Regards,
Pak Ricard
Find all posts by this user
Quote this message in a reply
07-21-2012, 02:45 PM
Post: #3
RE: Change order results in SelectProduct.php
Nice thanks....

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)