IRC logs of #tryton for Wednesday, 2019-11-13

chat.freenode.net #tryton log beginning Wed 13 Nov 2019 12:00:01 AM CET
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton23:37
-!- thaneor1(~lenovo3@r179-24-117-247.dialup.adsl.anteldata.net.uy) has joined #tryton03:29
-!- yangoon(~mathiasb@i6DFA87A5.versanet.de) has joined #tryton03:47
-!- odicha(~odicha@91.142.107.66) has joined #tryton07:19
-!- mrichez(~Maxime@mail.saluc.com) has joined #tryton07:30
-!- Timitos(~kpreisler@2001:a61:5a4:b101:762b:62ff:fe84:ed7e) has joined #tryton07:55
-!- buxy(~rhertzog@helios.freexian.com) has joined #tryton08:32
-!- josesalvador(~josesalva@84.124.29.26.static.user.ono.com) has joined #tryton08:37
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton08:37
-!- nicoe(~nicoe@2a02:2788:54:5a3:7e2a:31ff:fe5e:b25d) has joined #tryton09:08
-!- smorillo(05e19d41@gateway/web/cgi-irc/kiwiirc.com/ip.5.225.157.65) has joined #tryton09:09
mrichezhi, 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 #tryton10:26
-!- Timitos(~kpreisler@2001:a61:5a4:b101:762b:62ff:fe84:ed7e) has joined #tryton10:26
-!- mariomop(~quassel@181.228.29.59) has joined #tryton10:54
pokolimrichez: you should create a Grouping Module which references each move of the sale10:55
pokolimrichez: IIRC on the account_asset module there is something similar done10:55
cedkmrichez: you can use https://docs.python.org/3.5/library/itertools.html#itertools.groupby10:58
mrichezpokoli: ok thanks10:58
mrichezcedk: ok, i thought it could be done in the report, but i've to do that in python code in the report class10:59
-!- mariomop(~quassel@181.228.29.59) has joined #tryton11:09
cedkmrichez: you can call python code in report but it is not very practical11:11
mrichezcedk: 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 #tryton12:19
-!- josesalvador(~josesalva@170.253.46.251) has joined #tryton13:24
-!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton14:06
-!- thaneor(~lenovo3@179.26.116.108) has joined #tryton15:30
-!- user(~user@224.red-79-145-232.dynamicip.rima-tde.net) has joined #tryton15:31
-!- nicoe(~nicoe@188.189.170.84) has joined #tryton16:20
-!- andrespoliti(~andrespol@200.50.173.5) has joined #tryton18:52
andrespolitihi, 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 #tryton19:09
-!- Timitos(~kpreisler@2001:a61:5a4:b101:ae7b:a1ff:feaf:55f0) has joined #tryton19:09
cedkandrespoliti: I will not start by that20:19
cedkandrespoliti: 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/!