IRC logs of #tryton for Wednesday, 2019-11-13 #tryton log beginning Wed 13 Nov 2019 12:00:01 AM CET
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton23:37
-!- thaneor1( has joined #tryton03:29
-!- yangoon( has joined #tryton03:47
-!- odicha(~odicha@ has joined #tryton07:19
-!- mrichez( has joined #tryton07:30
-!- Timitos(~kpreisler@2001:a61:5a4:b101:762b:62ff:fe84:ed7e) has joined #tryton07:55
-!- buxy( has joined #tryton08:32
-!- josesalvador( 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/ 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@ 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
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@ 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( has joined #tryton12:19
-!- josesalvador(~josesalva@ has joined #tryton13:24
-!- nicoe( has joined #tryton14:06
-!- thaneor(~lenovo3@ has joined #tryton15:30
-!- user( has joined #tryton15:31
-!- nicoe(~nicoe@ has joined #tryton16:20
-!- andrespoliti(~andrespol@ 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@ 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 2.17.3 by Marius Gedminas - find it at!