IRC logs of #tryton for Friday, 2011-07-01

chat.freenode.net #tryton log beginning Fri Jul 1 00:00:02 CEST 2011
-!- bvillasanti(~bruno@190.105.104.81) has joined #tryton01:01
-!- sisalp(~dominique@annecy.sisalp.net) has joined #tryton01:49
-!- elbenfreund1(~elbenfreu@p54B95E1D.dip.t-dialin.net) has joined #tryton01:53
-!- saxa(~sasa@189.26.255.43) has joined #tryton02:02
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton03:03
-!- gremly(~gremly@200.106.202.91) has joined #tryton03:35
-!- alimon(~alimon@187.156.86.12) has joined #tryton04:39
-!- bvillasanti(~bruno@190.105.104.81) has left #tryton05:47
-!- plantian(~ian@c-67-169-72-36.hsd1.ca.comcast.net) has joined #tryton05:49
-!- vladimirek(~vladimire@adsl-dyn24.78-98-14.t-com.sk) has joined #tryton08:24
-!- mhi1(~mhi@pd95b104a.dip0.t-ipconnect.de) has joined #tryton08:24
-!- enlightx(~enlightx@static-217-133-61-144.clienti.tiscali.it) has joined #tryton08:51
-!- elbenfreund(~elbenfreu@p54B95E1D.dip.t-dialin.net) has joined #tryton08:59
-!- pjstevns(~pjstevns@a83-163-46-103.adsl.xs4all.nl) has joined #tryton09:01
-!- elbenfreund(~elbenfreu@82.113.99.32) has joined #tryton09:48
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton09:53
-!- yangoon(~mathiasb@p54B4FBF8.dip.t-dialin.net) has joined #tryton10:14
-!- blast_hardcheese(~blast_har@cpe-98-151-31-186.socal.res.rr.com) has joined #tryton10:18
-!- bechamel(~user@cismwks02-virtual1.cism.ucl.ac.be) has joined #tryton10:34
-!- okko(~okko@62.58.29.41) has joined #tryton10:42
-!- paepke(~paepke@gate.paepke.net) has joined #tryton11:06
-!- elbenfreund(~elbenfreu@p54B95E1D.dip.t-dialin.net) has joined #tryton12:13
-!- Red15(~red15@unaffiliated/red15) has joined #tryton13:08
Red15does the search view type not exist in tryton ?13:08
-!- ciupicri(~ciupicri@81.180.234.249) has joined #tryton13:28
bechamelRed15: what do you call search view type ?13:32
Red15as in openerp, it defines the the top part of the tree view and is used for searching (also grouping but i think that is implemented in tryton)13:32
Red15instead of having to use select="1" or select="2" on the form view to define which fields can be searched on13:33
bechamelRed15: there are no grouping feature on the search view, and the select option is defined on the model not on the view13:36
Red15are you sure ? select on the model usually does index keys in the rdbms13:36
cedkbechamel: it is defined in the view13:38
bechameloh yes sorry13:38
bechamelcedk: if I put no select on the view is the one defined on the model used as default value ?13:39
cedkbechamel: I don't think13:39
cedkanyway all of that will be removed with the new search13:40
cedkRed15: we don't implement group_by functionnality because it is a buggy design13:40
cedkRed15: we have much better way to have this kind of feature with the board communication13:41
Red15i think you underestimate the power this gives to non-technical managers to do rotations on their own13:41
cedkRed15: it doesn't work, it sum apples and oranges13:43
bechamelRed15: rotations ?13:43
Red15cedk, that is for the manager to decide13:43
Red15bechamel, like excel data pilot13:43
cedklet just see the sale form, it will sum amount of different currencies13:43
cedkRed15: it is not a pivot feature13:44
cedkRed15: it is just sum with grouping13:44
Red15well that's semantics13:44
Red15so how does tryton handle this then ?13:45
Red15(also btw the grouping is not the only nice functionality, the quick-access filters are also useful)13:46
cedkRed15: handle what?13:47
Red15cedk, reporting and pivot things13:48
cedkRed15: what do you mean by reporting?13:48
Red15well in-client analysis of data13:49
cedkRed15: and what do you mean by "pivot things"?13:49
bechamelRed15: when this kind of feature is needed we add and sql view and we plug a python model on top of it13:49
bechamelbut of course it's doable by the end user13:49
Red15suppose i want to see all sale order grouped by partner country and per month ?13:50
cedkRed15: create a view for that13:50
cedkRed15: by the way, this doesn't work in OE13:50
bechamel.. and because there is an real model under the view, it's possible to define a grap or add action on the agregate records13:51
cedkalso the query for a view can be dynamic depending of the context13:51
Red15cedk, does work in OE, (maybe apples + oranges, but that is user responsibility to group by currency)13:53
Red15cedk, context field has been added to openerp search views, which allows the user to change context on the fly13:53
cedkRed15: did you read the code of the group_by ?13:54
cedkit is a functionality just for sale. Like the "set default" we removed in the last release because in real life it doesn't work13:55
cedkRed15: otherwise if you want BI, just plug a BI software on the database13:56
cedkby the way, I never believe in end-user making queries13:58
cedkfrom my experiences, they always do mistakes: SUM wrong type, forget a grouping and just slow down the database13:59
cedkRed15: about your example in OE, you can not group by currency on sale because there is no currency on sale14:04
Red15fields.related('pricelist_id','currency_id') and voila14:04
cedkRed15: I don't think group_by works on function field14:05
Red15store=True ?14:05
cedkRed15: :-))))14:05
Red15or rather the more complex one saying that if pricelist changes the stored value should be recalculated14:06
cedkRed15: I was sure you will anwser this, this is the worse feature14:06
cedkduplicate information that is really bad DB design14:07
Red15but i'm not 100% sure that group_by wouldnt work on functional fields though14:08
Red15how would you solve this then ? always creating db views ?14:08
cedkRed15: there is no DB views in Tryton14:10
cedkRed15: we use dynamic (but controlled) queries14:10
Red15cant you create views with sqlalchemy etc?14:11
cedkRed15: you can easily create a Model that will have the same functionnality of the "group_by"14:11
Red15cedk, as programmer: likely14:11
cedkRed15: we don't create view, because it can not be migrated easily14:11
Red15cedk, as end-user: not-quite14:11
Red15ACTION starting to ponder about flat db's14:11
cedkRed15: and the Model can be as generic (ex: grouping on any fields, etc.)14:11
cedkRed15: but with this kind of Model, you can already fix the currency issue etc.14:12
cedkso the user can still have the possibility to select on what he will group14:13
Red15but how will you do the actual grouping ?14:14
cedkRed15: I will do it on the fly depending of what the user has selected14:15
Red15but visually ?14:15
cedkRed15: don't understand14:15
cedkRed15: look at http://hg2.tryton.org/modules/sale_opportunity/file/f4a0a4845ed3/opportunity.py#l42514:18
cedkACTION Lunch14:18
cedkACTION back14:44
Red15cedk, am i reading this right are you doing + on select strings ?15:08
Red15sql injection anyone ?15:08
cedkRed15: of course not15:15
-!- gremly(~gremly@200.106.202.91) has joined #tryton15:15
-!- nicoe(~nicoe@109-93-175-161.dynamic.isp.telekom.rs) has joined #tryton15:18
-!- nicoe(~nicoe@109-93-175-161.dynamic.isp.telekom.rs) has joined #tryton15:24
-!- heg(~heg@dyn.144-85-181-142.dsl.vtx.ch) has joined #tryton16:48
-!- udono(~udono@ip-95-222-129-145.unitymediagroup.de) has joined #tryton17:07
-!- Hoy(~andres-va@fixed-203-7-69.iusacell.net) has joined #tryton17:22
-!- nicoe(~nicoe@109-93-175-161.dynamic.isp.telekom.rs) has joined #tryton17:39
-!- enlightx(~enlightx@217.202.238.206) has joined #tryton17:42
-!- chrue(~chrue@dyndsl-091-096-061-196.ewe-ip-backbone.de) has joined #tryton17:53
-!- woakas(~woakas@200.106.202.91) has joined #tryton18:29
-!- nicoe(~nicoe@cable-178-148-1-63.dynamic.sbb.rs) has joined #tryton18:41
-!- gremly(~gremly@200.106.202.91) has joined #tryton18:41
-!- nicoe(~nicoe@cable-178-148-1-63.dynamic.sbb.rs) has joined #tryton18:45
-!- alimon(~alimon@187.156.86.12) has joined #tryton19:05
-!- enlightx(~enlightx@109.52.211.29) has joined #tryton19:20
-!- enlightx(~enlightx@109.52.211.29) has joined #tryton19:23
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton19:57
-!- enlightx(~enlightx@109.52.211.29) has joined #tryton20:10
-!- enlightx(~enlightx@109.52.211.29) has joined #tryton20:58
-!- alimon(~alimon@187.156.86.12) has joined #tryton21:10
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton21:24
-!- helmor(~helmo@46.115.22.86) has joined #tryton21:28
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton22:19
-!- blast_hardcheese(~blast_har@cpe-98-151-31-186.socal.res.rr.com) has joined #tryton22:23
-!- rhubner(~rhubner@189.58.55.3.dynamic.adsl.gvt.net.br) has joined #tryton22:47
-!- ciupicri(~ciupicri@81.180.234.249) has joined #tryton23:00
-!- gremly(~gremly@200.106.202.91) has joined #tryton23:51
-!- heg(~heg@dyn.144-85-181-142.dsl.vtx.ch) has left #tryton23:59

Generated by irclog2html.py 2.11.0 by Marius Gedminas - find it at mg.pov.lt!