> Afraid that won't help for function fields, as performing a correct > search/filter would still require loading the whole table - no magic bullet. true - but not at once, it would be incremental execpt for sort operations which of cours need the complete results
but beeing honest - how much extra time does it take to sort let's say 10000 records (products) in python memory using the results of function fields (compared to any other manual method)? the time to culculate the function field can be omitted, because if the user needs the full list sorted these must be calucalted in any case. > > IMHO there is no reason why filters can not be applied to results > > (appart that it is not coded) > > the "simple" rule > > domain > > * is DB field - add condition to SQL WHERE query > > * else filter results. > > would do it. > > My opinion is that this is very counter-intuitive and would be a great > cause of hidden mistakes for most users - how will they be able to tell > the difference between the two cases? why it is not the job of the user to decide on this, it's a one time coding issue put all database field condition in the SQL WHERE clause and filter the result of the SQL query using python just before displaying these. let' say the company wants to see all products with a stock value of >10000 OpenERP should be able to provide this info. and of course all records must be examined, but this is reality - organizations (and bosses) ask these sort of questions and we partners are looking really silly if we have to explain that the most advanced open source ERP can not to such "easy" tasks. -- ferdinand -- You received this bug notification because you are a member of C2C OERPScenario, which is subscribed to OpenERP Project Group. https://bugs.launchpad.net/bugs/850752 Title: fnct_search missing for many function fields Status in OpenERP Addons (modules): Won't Fix Bug description: according to https://bugs.launchpad.net/bugs/823049 it will be possible to search for function fields store = false if fnct_search is defined a quick search shows 280 function fields in addons 14 fnct_search it would enhance the user experience a lot if at least for the most important function a searech could be defined for 6.1 as it is the rebirth of a lost feature available in v5 it would also easy migration. will you implement search functions if we / the community nominates some important candidates ? like * product stock available / on hand To manage notifications about this bug go to: https://bugs.launchpad.net/openobject-addons/+bug/850752/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
