chat.freenode.net #tryton log beginning Wed 13 Nov 2019 12:00:01 AM CET | ||
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 23:37 | |
-!- thaneor1(~lenovo3@r179-24-117-247.dialup.adsl.anteldata.net.uy) has joined #tryton | 03:29 | |
-!- yangoon(~mathiasb@i6DFA87A5.versanet.de) has joined #tryton | 03:47 | |
-!- odicha(~odicha@91.142.107.66) has joined #tryton | 07:19 | |
-!- mrichez(~Maxime@mail.saluc.com) has joined #tryton | 07:30 | |
-!- Timitos(~kpreisler@2001:a61:5a4:b101:762b:62ff:fe84:ed7e) has joined #tryton | 07:55 | |
-!- buxy(~rhertzog@helios.freexian.com) has joined #tryton | 08:32 | |
-!- josesalvador(~josesalva@84.124.29.26.static.user.ono.com) has joined #tryton | 08:37 | |
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 08:37 | |
-!- nicoe(~nicoe@2a02:2788:54:5a3:7e2a:31ff:fe5e:b25d) has joined #tryton | 09:08 | |
-!- smorillo(05e19d41@gateway/web/cgi-irc/kiwiirc.com/ip.5.225.157.65) has joined #tryton | 09:09 | |
mrichez | hi, in relatorio, is there a way to group data in a loop for ? Here's my problem: In report picking list, there's a loop on the moves from the shipment... on a move there's a field "sale" , i would like to group moves by this field "sale" to display specific information linked to the sale, but i don't want to repeat information for each move linked to the same sale. Thanks for help! | 10:24 |
---|---|---|
-!- Timitos(~kpreisler@2001:a61:5a4:b101:762b:62ff:fe84:ed7e) has left #tryton | 10:26 | |
-!- Timitos(~kpreisler@2001:a61:5a4:b101:762b:62ff:fe84:ed7e) has joined #tryton | 10:26 | |
-!- mariomop(~quassel@181.228.29.59) has joined #tryton | 10:54 | |
pokoli | mrichez: you should create a Grouping Module which references each move of the sale | 10:55 |
pokoli | mrichez: IIRC on the account_asset module there is something similar done | 10:55 |
cedk | mrichez: you can use https://docs.python.org/3.5/library/itertools.html#itertools.groupby | 10:58 |
mrichez | pokoli: ok thanks | 10:58 |
mrichez | cedk: ok, i thought it could be done in the report, but i've to do that in python code in the report class | 10:59 |
-!- mariomop(~quassel@181.228.29.59) has joined #tryton | 11:09 | |
cedk | mrichez: you can call python code in report but it is not very practical | 11:11 |
mrichez | cedk: indeed... i was focused to try to group data on report, i'll group data in report class with groupby... thanks :-) | 11:13 |
-!- rpit(~rpit@p5df0535b.dip0.t-ipconnect.de) has joined #tryton | 12:19 | |
-!- josesalvador(~josesalva@170.253.46.251) has joined #tryton | 13:24 | |
-!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton | 14:06 | |
-!- thaneor(~lenovo3@179.26.116.108) has joined #tryton | 15:30 | |
-!- user(~user@224.red-79-145-232.dynamicip.rima-tde.net) has joined #tryton | 15:31 | |
-!- nicoe(~nicoe@188.189.170.84) has joined #tryton | 16:20 | |
-!- andrespoliti(~andrespol@200.50.173.5) has joined #tryton | 18:52 | |
andrespoliti | hi, i have a report that makes a complex search in account_move_line. Would it be possible to make it more performant by partitioning the account_move_line table between reconciled and unreconciled move lines? | 18:56 |
-!- josesalvador(~josesalva@170.253.46.226) has joined #tryton | 19:09 | |
-!- Timitos(~kpreisler@2001:a61:5a4:b101:ae7b:a1ff:feaf:55f0) has joined #tryton | 19:09 | |
cedk | andrespoliti: I will not start by that | 20:19 |
cedk | andrespoliti: first simplify the query, add proper indexes, tune PG parameters… | 20:20 |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!