| chat.freenode.net #tryton log beginning Thu Sep 7 00:00:01 CEST 2017 | ||
| 2017-09-07 00:39 -!- smarro(~sebastian@207.110.29.138.ptr.us.xo.net) has joined #tryton | ||
| 2017-09-07 00:43 -!- thaneor1(~ldlc6@r179-25-99-195.dialup.adsl.anteldata.net.uy) has joined #tryton | ||
| 2017-09-07 01:21 -!- kstenger(~karla@r186-54-40-193.dialup.adsl.anteldata.net.uy) has joined #tryton | ||
| 2017-09-07 01:34 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2017-09-07 02:10 -!- smarro(~sebastian@207.110.29.138.ptr.us.xo.net) has joined #tryton | ||
| 2017-09-07 02:10 -!- cdchapman(~perturbed@73.98.169.187) has joined #tryton | ||
| 2017-09-07 02:31 -!- cdchapman(~perturbed@73.98.169.180) has joined #tryton | ||
| 2017-09-07 02:46 -!- cdchapman(~perturbed@73.98.169.110) has joined #tryton | ||
| 2017-09-07 02:52 -!- cdchapman(~perturbed@73.98.169.110) has joined #tryton | ||
| 2017-09-07 03:25 -!- cdchapman(~perturbed@73.98.169.110) has joined #tryton | ||
| 2017-09-07 03:35 -!- cdchapman(~perturbed@73.98.169.110) has joined #tryton | ||
| 2017-09-07 04:44 -!- perilla_(~perilla@186.43.140.47) has joined #tryton | ||
| 2017-09-07 06:21 -!- robinak(~quassel@unaffilated/robink) has joined #tryton | ||
| 2017-09-07 06:50 -!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton | ||
| 2017-09-07 06:51 -!- cdchapman(~perturbed@73.98.169.203) has joined #tryton | ||
| 2017-09-07 08:02 -!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton | ||
| 2017-09-07 08:03 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2017-09-07 08:24 -!- rpit(~rpit@2a02:908:e671:9f80:56ee:75ff:fe0d:d3c7) has joined #tryton | ||
| 2017-09-07 08:34 -!- thaneor(~ldlc6@r179-24-119-105.dialup.adsl.anteldata.net.uy) has joined #tryton | ||
| 2017-09-07 08:56 -!- mrichez(~smuxi@mail.saluc.com) has joined #tryton | ||
| 2017-09-07 09:00 -!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton | ||
| 2017-09-07 09:23 -!- raarts(~raarts@92.109.222.149) has joined #tryton | ||
| 2017-09-07 09:24 -!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton | ||
| 2017-09-07 09:26 -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton | ||
| 2017-09-07 10:32 -!- raarts(~raarts@92.109.222.149) has joined #tryton | ||
| 2017-09-07 11:49 -!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton | ||
| 2017-09-07 11:58 -!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton | ||
| 2017-09-07 12:46 -!- mariomop(~quassel@181.111.65.217) has joined #tryton | ||
| 2017-09-07 13:14 -!- nicoe(~nicoe@2a02:578:858c:500:ee55:f9ff:fe7b:f7ac) has joined #tryton | ||
| 2017-09-07 13:21 -!- dmollerm(~dmollerm@170.red-80-28-119.staticip.rima-tde.net) has joined #tryton | ||
| 2017-09-07 13:33 <dmollerm> Hi. 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 co | ||
| 2017-09-07 13:33 <dmollerm> lumns 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? | ||
| 2017-09-07 13:45 <cedk> dmollerm: I do not think we should add a default group_by because it will have performence degradation | ||
| 2017-09-07 13:46 <cedk> dmollerm: but indeed I think you must join on already aggrgated subquery which contains the Max value | ||
| 2017-09-07 13:46 <cedk> dmollerm: so the join will not create a cartesian product | ||
| 2017-09-07 13:49 -!- meigallodixital(~meigallod@249.135.116.91.static.reverse-mundo-r.com) has joined #tryton | ||
| 2017-09-07 13:50 <dmollerm> cedk: indeed, no need to run the tests, a default group_by clause broke some views. | ||
| 2017-09-07 13:52 <dmollerm> cedk: 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. | ||
| 2017-09-07 13:53 <cedk> dmollerm: https://stackoverflow.com/questions/16776176/sql-left-join-subquery-alias | ||
| 2017-09-07 13:54 <cedk> dmollerm: so write a SQL query that returns the id and the value of your function field | ||
| 2017-09-07 13:54 <cedk> dmollerm: and join on this query | ||
| 2017-09-07 13:54 <cedk> dmollerm: and order on the column of this query | ||
| 2017-09-07 13:55 <dmollerm> cedk: makes sense, I'll try it out thanks | ||
| 2017-09-07 14:00 <dmollerm> cedk: indeed, works like a charm. thanks! | ||
| 2017-09-07 14:36 -!- smarro(~sebastian@207.110.29.138.ptr.us.xo.net) has joined #tryton | ||
| 2017-09-07 14:47 <sisalp> hello, 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 ? | ||
| 2017-09-07 14:52 <cedk> sisalp: I do not see them as ergonomic, they are just playful | ||
| 2017-09-07 15:18 -!- csotelo_at_work(~csotelo@179.43.97.56) has joined #tryton | ||
| 2017-09-07 15:57 -!- mariomop(~quassel@200.117.92.152) has joined #tryton | ||
| 2017-09-07 15:59 -!- cdchapman(~perturbed@73.98.169.86) has joined #tryton | ||
| 2017-09-07 16:01 -!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton | ||
| 2017-09-07 16:08 -!- kstenger(~karla@r186-50-60-242.dialup.adsl.anteldata.net.uy) has joined #tryton | ||
| 2017-09-07 16:08 -!- meigallodixital(~meigallod@249.135.116.91.static.reverse-mundo-r.com) has joined #tryton | ||
| 2017-09-07 17:04 -!- andrespoliti(~andrespol@250-183-89-200.fibertel.com.ar) has joined #tryton | ||
| 2017-09-07 17:04 <andrespoliti> hello! is it possible to include record information in the header of a report? | ||
| 2017-09-07 17:05 <andrespoliti> i need a header with the company logo in each page, but i also need some record fields in the header | ||
| 2017-09-07 17:07 <cedk> andrespoliti: you would need https://bugs.tryton.org/issue6640 | ||
| 2017-09-07 17:11 -!- semarie(~semarie@unaffiliated/semarie) has joined #tryton | ||
| 2017-09-07 17:15 <andrespoliti> do you mean the invoice.odt example? | ||
| 2017-09-07 17:16 <andrespoliti> that template only works with 1 report, right? | ||
| 2017-09-07 17:17 <andrespoliti> it has no for each record loop | ||
| 2017-09-07 17:23 <cedk> andrespoliti: yes | ||
| 2017-09-07 18:12 -!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton | ||
| 2017-09-07 18:13 -!- lukio(~lukio@200.68.72.41) has joined #tryton | ||
| 2017-09-07 18:49 -!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has joined #tryton | ||
| 2017-09-07 18:51 -!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton | ||
| 2017-09-07 19:10 -!- JanGB(~jan@p2003000621E867502564DC0482045059.dip0.t-ipconnect.de) has joined #tryton | ||
| 2017-09-07 19:14 -!- cdchapman(~perturbed@73.98.169.156) has joined #tryton | ||
| 2017-09-07 19:26 -!- JanGB(~jan@p5DF2C771.dip0.t-ipconnect.de) has joined #tryton | ||
| 2017-09-07 19:43 -!- JanGB(~jan@p2003000621E867502564DC0482045059.dip0.t-ipconnect.de) has joined #tryton | ||
| 2017-09-07 19:50 -!- JanGB(~jan@p2003000621E867502564DC0482045059.dip0.t-ipconnect.de) has joined #tryton | ||
| 2017-09-07 19:54 -!- lukio(~lukio@host126.186-109-85.telecom.net.ar) has joined #tryton | ||
| 2017-09-07 19:59 -!- JanGB(~jan@x2f7fa0a.dyn.telefonica.de) has joined #tryton | ||
| 2017-09-07 20:36 -!- cdchapman(~perturbed@73.98.163.54) has joined #tryton | ||
| 2017-09-07 20:37 -!- thaneor(~ldlc6@r179-24-114-126.dialup.adsl.anteldata.net.uy) has joined #tryton | ||
| 2017-09-07 21:14 -!- JosDzG(~Thunderbi@189.250.86.49) has joined #tryton | ||
| 2017-09-07 22:01 -!- semarie_(~semarie@unaffiliated/semarie) has joined #tryton | ||
| 2017-09-07 23:32 -!- lukio(~lukio@host126.186-109-85.telecom.net.ar) has left #tryton |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!