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 #tryton00:11
-!- thaneor1(~lenovo3@r179-24-117-247.dialup.adsl.anteldata.net.uy) has joined #tryton04:11
-!- yangoon(~mathiasb@i6DFA87A5.versanet.de) has joined #tryton04:11
-!- odicha(~odicha@91.142.107.66) has joined #tryton08:11
-!- mrichez(~Maxime@mail.saluc.com) has joined #tryton08:11
-!- Timitos(~kpreisler@2001:a61:5a4:b101:762b:62ff:fe84:ed7e) has joined #tryton08:11
-!- buxy(~rhertzog@helios.freexian.com) has joined #tryton09:11
-!- josesalvador(~josesalva@84.124.29.26.static.user.ono.com) has joined #tryton09:11
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton09:11
-!- nicoe(~nicoe@2a02:2788:54:5a3:7e2a:31ff:fe5e:b25d) has joined #tryton10:11
-!- smorillo(05e19d41@gateway/web/cgi-irc/kiwiirc.com/ip.5.225.157.65) has joined #tryton10:11
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!11:11
-!- Timitos(~kpreisler@2001:a61:5a4:b101:762b:62ff:fe84:ed7e) has left #tryton11:11
-!- Timitos(~kpreisler@2001:a61:5a4:b101:762b:62ff:fe84:ed7e) has joined #tryton11:11
-!- mariomop(~quassel@181.228.29.59) has joined #tryton11:11
pokolimrichez: you should create a Grouping Module which references each move of the sale11:11
pokolimrichez: IIRC on the account_asset module there is something similar done11:11
cedkmrichez: you can use https://docs.python.org/3.5/library/itertools.html#itertools.groupby11:11
mrichezpokoli: ok thanks11:11
mrichezcedk: ok, i thought it could be done in the report, but i've to do that in python code in the report class11:11
-!- mariomop(~quassel@181.228.29.59) has joined #tryton12:11
cedkmrichez: you can call python code in report but it is not very practical12:11
mrichezcedk: indeed... i was focused to try to group data on report, i'll group data in report class with groupby... thanks :-)12:11
-!- rpit(~rpit@p5df0535b.dip0.t-ipconnect.de) has joined #tryton13:11
-!- josesalvador(~josesalva@170.253.46.251) has joined #tryton14:11
-!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton15:11
-!- thaneor(~lenovo3@179.26.116.108) has joined #tryton16:11
-!- user(~user@224.red-79-145-232.dynamicip.rima-tde.net) has joined #tryton16:11
-!- nicoe(~nicoe@188.189.170.84) has joined #tryton17:11
-!- andrespoliti(~andrespol@200.50.173.5) has joined #tryton19:11
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?19:11
-!- josesalvador(~josesalva@170.253.46.226) has joined #tryton20:11
-!- Timitos(~kpreisler@2001:a61:5a4:b101:ae7b:a1ff:feaf:55f0) has joined #tryton20:11
cedkandrespoliti: I will not start by that21:11
cedkandrespoliti: first simplify the query, add proper indexes, tune PG parameters…21:11

Generated by irclog2html.py 2.16.0 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!