c2c-oerpscenario team mailing list archive

["Ferdinand @ Camptocamp" <850752@xxxxxxxxxxxxxxxxxx>]

> 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