| chat.freenode.net #tryton log beginning Fri Jul 1 00:00:02 CEST 2011 | ||
| 2011-07-01 01:01 -!- bvillasanti(~bruno@190.105.104.81) has joined #tryton | ||
| 2011-07-01 01:49 -!- sisalp(~dominique@annecy.sisalp.net) has joined #tryton | ||
| 2011-07-01 01:53 -!- elbenfreund1(~elbenfreu@p54B95E1D.dip.t-dialin.net) has joined #tryton | ||
| 2011-07-01 02:02 -!- saxa(~sasa@189.26.255.43) has joined #tryton | ||
| 2011-07-01 03:03 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-07-01 03:35 -!- gremly(~gremly@200.106.202.91) has joined #tryton | ||
| 2011-07-01 04:39 -!- alimon(~alimon@187.156.86.12) has joined #tryton | ||
| 2011-07-01 05:47 -!- bvillasanti(~bruno@190.105.104.81) has left #tryton | ||
| 2011-07-01 05:49 -!- plantian(~ian@c-67-169-72-36.hsd1.ca.comcast.net) has joined #tryton | ||
| 2011-07-01 08:24 -!- vladimirek(~vladimire@adsl-dyn24.78-98-14.t-com.sk) has joined #tryton | ||
| 2011-07-01 08:24 -!- mhi1(~mhi@pd95b104a.dip0.t-ipconnect.de) has joined #tryton | ||
| 2011-07-01 08:51 -!- enlightx(~enlightx@static-217-133-61-144.clienti.tiscali.it) has joined #tryton | ||
| 2011-07-01 08:59 -!- elbenfreund(~elbenfreu@p54B95E1D.dip.t-dialin.net) has joined #tryton | ||
| 2011-07-01 09:01 -!- pjstevns(~pjstevns@a83-163-46-103.adsl.xs4all.nl) has joined #tryton | ||
| 2011-07-01 09:48 -!- elbenfreund(~elbenfreu@82.113.99.32) has joined #tryton | ||
| 2011-07-01 09:53 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2011-07-01 10:14 -!- yangoon(~mathiasb@p54B4FBF8.dip.t-dialin.net) has joined #tryton | ||
| 2011-07-01 10:18 -!- blast_hardcheese(~blast_har@cpe-98-151-31-186.socal.res.rr.com) has joined #tryton | ||
| 2011-07-01 10:34 -!- bechamel(~user@cismwks02-virtual1.cism.ucl.ac.be) has joined #tryton | ||
| 2011-07-01 10:42 -!- okko(~okko@62.58.29.41) has joined #tryton | ||
| 2011-07-01 11:06 -!- paepke(~paepke@gate.paepke.net) has joined #tryton | ||
| 2011-07-01 12:13 -!- elbenfreund(~elbenfreu@p54B95E1D.dip.t-dialin.net) has joined #tryton | ||
| 2011-07-01 13:08 -!- Red15(~red15@unaffiliated/red15) has joined #tryton | ||
| 2011-07-01 13:08 <Red15> does the search view type not exist in tryton ? | ||
| 2011-07-01 13:28 -!- ciupicri(~ciupicri@81.180.234.249) has joined #tryton | ||
| 2011-07-01 13:32 <bechamel> Red15: what do you call search view type ? | ||
| 2011-07-01 13:32 <Red15> as 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) | ||
| 2011-07-01 13:33 <Red15> instead of having to use select="1" or select="2" on the form view to define which fields can be searched on | ||
| 2011-07-01 13:36 <bechamel> Red15: there are no grouping feature on the search view, and the select option is defined on the model not on the view | ||
| 2011-07-01 13:36 <Red15> are you sure ? select on the model usually does index keys in the rdbms | ||
| 2011-07-01 13:38 <cedk> bechamel: it is defined in the view | ||
| 2011-07-01 13:38 <bechamel> oh yes sorry | ||
| 2011-07-01 13:39 <bechamel> cedk: if I put no select on the view is the one defined on the model used as default value ? | ||
| 2011-07-01 13:39 <cedk> bechamel: I don't think | ||
| 2011-07-01 13:40 <cedk> anyway all of that will be removed with the new search | ||
| 2011-07-01 13:40 <cedk> Red15: we don't implement group_by functionnality because it is a buggy design | ||
| 2011-07-01 13:41 <cedk> Red15: we have much better way to have this kind of feature with the board communication | ||
| 2011-07-01 13:41 <Red15> i think you underestimate the power this gives to non-technical managers to do rotations on their own | ||
| 2011-07-01 13:43 <cedk> Red15: it doesn't work, it sum apples and oranges | ||
| 2011-07-01 13:43 <bechamel> Red15: rotations ? | ||
| 2011-07-01 13:43 <Red15> cedk, that is for the manager to decide | ||
| 2011-07-01 13:43 <Red15> bechamel, like excel data pilot | ||
| 2011-07-01 13:43 <cedk> let just see the sale form, it will sum amount of different currencies | ||
| 2011-07-01 13:44 <cedk> Red15: it is not a pivot feature | ||
| 2011-07-01 13:44 <cedk> Red15: it is just sum with grouping | ||
| 2011-07-01 13:44 <Red15> well that's semantics | ||
| 2011-07-01 13:45 <Red15> so how does tryton handle this then ? | ||
| 2011-07-01 13:46 <Red15> (also btw the grouping is not the only nice functionality, the quick-access filters are also useful) | ||
| 2011-07-01 13:47 <cedk> Red15: handle what? | ||
| 2011-07-01 13:48 <Red15> cedk, reporting and pivot things | ||
| 2011-07-01 13:48 <cedk> Red15: what do you mean by reporting? | ||
| 2011-07-01 13:49 <Red15> well in-client analysis of data | ||
| 2011-07-01 13:49 <cedk> Red15: and what do you mean by "pivot things"? | ||
| 2011-07-01 13:49 <bechamel> Red15: when this kind of feature is needed we add and sql view and we plug a python model on top of it | ||
| 2011-07-01 13:49 <bechamel> but of course it's doable by the end user | ||
| 2011-07-01 13:50 <Red15> suppose i want to see all sale order grouped by partner country and per month ? | ||
| 2011-07-01 13:50 <cedk> Red15: create a view for that | ||
| 2011-07-01 13:50 <cedk> Red15: by the way, this doesn't work in OE | ||
| 2011-07-01 13:51 <bechamel> .. and because there is an real model under the view, it's possible to define a grap or add action on the agregate records | ||
| 2011-07-01 13:51 <cedk> also the query for a view can be dynamic depending of the context | ||
| 2011-07-01 13:53 <Red15> cedk, does work in OE, (maybe apples + oranges, but that is user responsibility to group by currency) | ||
| 2011-07-01 13:53 <Red15> cedk, context field has been added to openerp search views, which allows the user to change context on the fly | ||
| 2011-07-01 13:54 <cedk> Red15: did you read the code of the group_by ? | ||
| 2011-07-01 13:55 <cedk> it is a functionality just for sale. Like the "set default" we removed in the last release because in real life it doesn't work | ||
| 2011-07-01 13:56 <cedk> Red15: otherwise if you want BI, just plug a BI software on the database | ||
| 2011-07-01 13:58 <cedk> by the way, I never believe in end-user making queries | ||
| 2011-07-01 13:59 <cedk> from my experiences, they always do mistakes: SUM wrong type, forget a grouping and just slow down the database | ||
| 2011-07-01 14:04 <cedk> Red15: about your example in OE, you can not group by currency on sale because there is no currency on sale | ||
| 2011-07-01 14:04 <Red15> fields.related('pricelist_id','currency_id') and voila | ||
| 2011-07-01 14:05 <cedk> Red15: I don't think group_by works on function field | ||
| 2011-07-01 14:05 <Red15> store=True ? | ||
| 2011-07-01 14:05 <cedk> Red15: :-)))) | ||
| 2011-07-01 14:06 <Red15> or rather the more complex one saying that if pricelist changes the stored value should be recalculated | ||
| 2011-07-01 14:06 <cedk> Red15: I was sure you will anwser this, this is the worse feature | ||
| 2011-07-01 14:07 <cedk> duplicate information that is really bad DB design | ||
| 2011-07-01 14:08 <Red15> but i'm not 100% sure that group_by wouldnt work on functional fields though | ||
| 2011-07-01 14:08 <Red15> how would you solve this then ? always creating db views ? | ||
| 2011-07-01 14:10 <cedk> Red15: there is no DB views in Tryton | ||
| 2011-07-01 14:10 <cedk> Red15: we use dynamic (but controlled) queries | ||
| 2011-07-01 14:11 <Red15> cant you create views with sqlalchemy etc? | ||
| 2011-07-01 14:11 <cedk> Red15: you can easily create a Model that will have the same functionnality of the "group_by" | ||
| 2011-07-01 14:11 <Red15> cedk, as programmer: likely | ||
| 2011-07-01 14:11 <cedk> Red15: we don't create view, because it can not be migrated easily | ||
| 2011-07-01 14:11 <Red15> cedk, as end-user: not-quite | ||
| 2011-07-01 14:11 <Red15> ACTION starting to ponder about flat db's | ||
| 2011-07-01 14:11 <cedk> Red15: and the Model can be as generic (ex: grouping on any fields, etc.) | ||
| 2011-07-01 14:12 <cedk> Red15: but with this kind of Model, you can already fix the currency issue etc. | ||
| 2011-07-01 14:13 <cedk> so the user can still have the possibility to select on what he will group | ||
| 2011-07-01 14:14 <Red15> but how will you do the actual grouping ? | ||
| 2011-07-01 14:15 <cedk> Red15: I will do it on the fly depending of what the user has selected | ||
| 2011-07-01 14:15 <Red15> but visually ? | ||
| 2011-07-01 14:15 <cedk> Red15: don't understand | ||
| 2011-07-01 14:18 <cedk> Red15: look at http://hg2.tryton.org/modules/sale_opportunity/file/f4a0a4845ed3/opportunity.py#l425 | ||
| 2011-07-01 14:18 <cedk> ACTION Lunch | ||
| 2011-07-01 14:44 <cedk> ACTION back | ||
| 2011-07-01 15:08 <Red15> cedk, am i reading this right are you doing + on select strings ? | ||
| 2011-07-01 15:08 <Red15> sql injection anyone ? | ||
| 2011-07-01 15:15 <cedk> Red15: of course not | ||
| 2011-07-01 15:15 -!- gremly(~gremly@200.106.202.91) has joined #tryton | ||
| 2011-07-01 15:18 -!- nicoe(~nicoe@109-93-175-161.dynamic.isp.telekom.rs) has joined #tryton | ||
| 2011-07-01 15:24 -!- nicoe(~nicoe@109-93-175-161.dynamic.isp.telekom.rs) has joined #tryton | ||
| 2011-07-01 16:48 -!- heg(~heg@dyn.144-85-181-142.dsl.vtx.ch) has joined #tryton | ||
| 2011-07-01 17:07 -!- udono(~udono@ip-95-222-129-145.unitymediagroup.de) has joined #tryton | ||
| 2011-07-01 17:22 -!- Hoy(~andres-va@fixed-203-7-69.iusacell.net) has joined #tryton | ||
| 2011-07-01 17:39 -!- nicoe(~nicoe@109-93-175-161.dynamic.isp.telekom.rs) has joined #tryton | ||
| 2011-07-01 17:42 -!- enlightx(~enlightx@217.202.238.206) has joined #tryton | ||
| 2011-07-01 17:53 -!- chrue(~chrue@dyndsl-091-096-061-196.ewe-ip-backbone.de) has joined #tryton | ||
| 2011-07-01 18:29 -!- woakas(~woakas@200.106.202.91) has joined #tryton | ||
| 2011-07-01 18:41 -!- nicoe(~nicoe@cable-178-148-1-63.dynamic.sbb.rs) has joined #tryton | ||
| 2011-07-01 18:41 -!- gremly(~gremly@200.106.202.91) has joined #tryton | ||
| 2011-07-01 18:45 -!- nicoe(~nicoe@cable-178-148-1-63.dynamic.sbb.rs) has joined #tryton | ||
| 2011-07-01 19:05 -!- alimon(~alimon@187.156.86.12) has joined #tryton | ||
| 2011-07-01 19:20 -!- enlightx(~enlightx@109.52.211.29) has joined #tryton | ||
| 2011-07-01 19:23 -!- enlightx(~enlightx@109.52.211.29) has joined #tryton | ||
| 2011-07-01 19:57 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-07-01 20:10 -!- enlightx(~enlightx@109.52.211.29) has joined #tryton | ||
| 2011-07-01 20:58 -!- enlightx(~enlightx@109.52.211.29) has joined #tryton | ||
| 2011-07-01 21:10 -!- alimon(~alimon@187.156.86.12) has joined #tryton | ||
| 2011-07-01 21:24 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-07-01 21:28 -!- helmor(~helmo@46.115.22.86) has joined #tryton | ||
| 2011-07-01 22:19 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-07-01 22:23 -!- blast_hardcheese(~blast_har@cpe-98-151-31-186.socal.res.rr.com) has joined #tryton | ||
| 2011-07-01 22:47 -!- rhubner(~rhubner@189.58.55.3.dynamic.adsl.gvt.net.br) has joined #tryton | ||
| 2011-07-01 23:00 -!- ciupicri(~ciupicri@81.180.234.249) has joined #tryton | ||
| 2011-07-01 23:51 -!- gremly(~gremly@200.106.202.91) has joined #tryton | ||
| 2011-07-01 23:59 -!- heg(~heg@dyn.144-85-181-142.dsl.vtx.ch) has left #tryton |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!