Hi Cedric,
we have a huge number of products, But we don't have huge number of
pricelists,
Therefore returning a result of pricelist which contains the specific
product is not too much.
do you know what is not beautiful to do it ?
when we select any value and then we set the small search box before
the value , i have to ready it using clause[1] and write functions to
do that,
for example if user select "Equals" and then typed something i have to
do "==" in my search() method.for example currently my search only
supports users to type the complete name of the products as it only do
simple comparision (==)
so i have to define 5 different search method based on the value of
clause[1].
In case of normal fields, it is as easy as putting (field name
clause[1:]) and return it so other jobs can be done in ORM
But it is logical and i think it worths.
But in case of searching for these kind of relations, when we have
huge data what kind of search technique is better from performance
point of view.
navigation and iteration using for statement
for all pricelist:
for all contracts:
for all products
if product = something:
return id
or using internal search() command search (domain = [something] )
or probably other ways.
Bytheway i have to mention that my functional field is a simple text
filed not a relational field and actually it does nothing and i just
use it to take control of the Treeview interface to have a searchbox !
Probably better performance but not sure !
Thanks for Remarks,
Mohammad
On Nov 3, 4:30 pm, Cédric Krier <[email protected]> wrote:
> On 02/11/10 18:38 -0700, Mohammad wrote:
>
> > In my opinion, it works fine now(Of course with some limitations), and
> > as we have some similar search issues within my module and the other
> > modules, we finally have to make our last decision to write them all
> > using a technique .
> > Therefore i would like to ask you whether it is possible to use this
> > technique or not.
>
> There is no general answer to this. There is some possible issue when passing
> long list of ids. In fact, you can pass any field of the Model in the result
> of a searcher function except the function field because it will create a
> infinite loop.
>
> --
> Cédric Krier
>
> B2CK SPRL
> Rue de Rotterdam, 4
> 4000 Liège
> Belgium
> Tel: +32 472 54 46 59
> Email/Jabber: [email protected]
> Website:http://www.b2ck.com/
>
> application_pgp-signature_part
> < 1KViewDownload
--
[email protected] mailing list
