IRC logs of #tryton for Thursday, 2017-09-07

chat.freenode.net #tryton log beginning Thu Sep 7 00:00:01 CEST 2017
-!- smarro(~sebastian@207.110.29.138.ptr.us.xo.net) has joined #tryton00:39
-!- thaneor1(~ldlc6@r179-25-99-195.dialup.adsl.anteldata.net.uy) has joined #tryton00:43
-!- kstenger(~karla@r186-54-40-193.dialup.adsl.anteldata.net.uy) has joined #tryton01:21
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton01:34
-!- smarro(~sebastian@207.110.29.138.ptr.us.xo.net) has joined #tryton02:10
-!- cdchapman(~perturbed@73.98.169.187) has joined #tryton02:10
-!- cdchapman(~perturbed@73.98.169.180) has joined #tryton02:31
-!- cdchapman(~perturbed@73.98.169.110) has joined #tryton02:46
-!- cdchapman(~perturbed@73.98.169.110) has joined #tryton02:52
-!- cdchapman(~perturbed@73.98.169.110) has joined #tryton03:25
-!- cdchapman(~perturbed@73.98.169.110) has joined #tryton03:35
-!- perilla_(~perilla@186.43.140.47) has joined #tryton04:44
-!- robinak(~quassel@unaffilated/robink) has joined #tryton06:21
-!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton06:50
-!- cdchapman(~perturbed@73.98.169.203) has joined #tryton06:51
-!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton08:02
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton08:03
-!- rpit(~rpit@2a02:908:e671:9f80:56ee:75ff:fe0d:d3c7) has joined #tryton08:24
-!- thaneor(~ldlc6@r179-24-119-105.dialup.adsl.anteldata.net.uy) has joined #tryton08:34
-!- mrichez(~smuxi@mail.saluc.com) has joined #tryton08:56
-!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton09:00
-!- raarts(~raarts@92.109.222.149) has joined #tryton09:23
-!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton09:24
-!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton09:26
-!- raarts(~raarts@92.109.222.149) has joined #tryton10:32
-!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton11:49
-!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton11:58
-!- mariomop(~quassel@181.111.65.217) has joined #tryton12:46
-!- nicoe(~nicoe@2a02:578:858c:500:ee55:f9ff:fe7b:f7ac) has joined #tryton13:14
-!- dmollerm(~dmollerm@170.red-80-28-119.staticip.rima-tde.net) has joined #tryton13:21
dmollermHi. We need some insight on the ordering of a functional field: the functional field outcome is an aggregated function (max) after a join with another table. In our order_fname function we can't return an sql.aggregate.Max operator because the group_by clause won't be added by ModelSql. But in the tables nested dictionary we can't replace the root table by a select where we already perform the group and agreggate because the co13:33
dmollermlumns that will be requested are arbitrary. Is this possible at all? Is there any example of this in a module? Would it harm if modelsql always added a group_by=main_table.id clause?13:33
cedkdmollerm: I do not think we should add a default group_by because it will have performence degradation13:45
cedkdmollerm: but indeed I think you must join on already aggrgated subquery which contains the Max value13:46
cedkdmollerm: so the join will not create a cartesian product13:46
-!- meigallodixital(~meigallod@249.135.116.91.static.reverse-mundo-r.com) has joined #tryton13:49
dmollermcedk: indeed, no need to run the tests, a default group_by clause broke some views.13:50
dmollermcedk: yet, replacing the root table by a select yields some concerns: how should the columns be selected and that the other tables join conditions must be exchanged to point to our select object.13:52
cedkdmollerm: https://stackoverflow.com/questions/16776176/sql-left-join-subquery-alias13:53
cedkdmollerm: so write a SQL query that returns the id and the value of your function field13:54
cedkdmollerm: and join on this query13:54
cedkdmollerm: and order on the column of this query13:54
dmollermcedk: makes sense, I'll try it out thanks13:55
dmollermcedk: indeed, works like a charm. thanks!14:00
-!- smarro(~sebastian@207.110.29.138.ptr.us.xo.net) has joined #tryton14:36
sisalphello, did some of you already get requirements for what Odoo calls kanban view, which is a collection of labels sorted in columns, every column being a status ?14:47
cedksisalp: I do not see them as ergonomic, they are just playful14:52
-!- csotelo_at_work(~csotelo@179.43.97.56) has joined #tryton15:18
-!- mariomop(~quassel@200.117.92.152) has joined #tryton15:57
-!- cdchapman(~perturbed@73.98.169.86) has joined #tryton15:59
-!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton16:01
-!- kstenger(~karla@r186-50-60-242.dialup.adsl.anteldata.net.uy) has joined #tryton16:08
-!- meigallodixital(~meigallod@249.135.116.91.static.reverse-mundo-r.com) has joined #tryton16:08
-!- andrespoliti(~andrespol@250-183-89-200.fibertel.com.ar) has joined #tryton17:04
andrespolitihello! is it possible to include record information in the header of a report?17:04
andrespolitii need a header with the company logo in each page, but i also need some record fields in the header17:05
cedkandrespoliti: you would need https://bugs.tryton.org/issue664017:07
-!- semarie(~semarie@unaffiliated/semarie) has joined #tryton17:11
andrespolitido you mean the invoice.odt example?17:15
andrespolitithat template only works with 1 report, right?17:16
andrespolitiit has no for each record loop17:17
cedkandrespoliti: yes17:23
-!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton18:12
-!- lukio(~lukio@200.68.72.41) has joined #tryton18:13
-!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has joined #tryton18:49
-!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton18:51
-!- JanGB(~jan@p2003000621E867502564DC0482045059.dip0.t-ipconnect.de) has joined #tryton19:10
-!- cdchapman(~perturbed@73.98.169.156) has joined #tryton19:14
-!- JanGB(~jan@p5DF2C771.dip0.t-ipconnect.de) has joined #tryton19:26
-!- JanGB(~jan@p2003000621E867502564DC0482045059.dip0.t-ipconnect.de) has joined #tryton19:43
-!- JanGB(~jan@p2003000621E867502564DC0482045059.dip0.t-ipconnect.de) has joined #tryton19:50
-!- lukio(~lukio@host126.186-109-85.telecom.net.ar) has joined #tryton19:54
-!- JanGB(~jan@x2f7fa0a.dyn.telefonica.de) has joined #tryton19:59
-!- cdchapman(~perturbed@73.98.163.54) has joined #tryton20:36
-!- thaneor(~ldlc6@r179-24-114-126.dialup.adsl.anteldata.net.uy) has joined #tryton20:37
-!- JosDzG(~Thunderbi@189.250.86.49) has joined #tryton21:14
-!- semarie_(~semarie@unaffiliated/semarie) has joined #tryton22:01
-!- lukio(~lukio@host126.186-109-85.telecom.net.ar) has left #tryton23:32

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