IRC logs of #tryton for Thursday, 2021-04-08

chat.freenode.net #tryton log beginning Thu Apr 8 12:00:01 AM CEST 2021
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton00:04
-!- srgdts_(~srgdts@unaffiliated/srgdts) has joined #tryton03:04
-!- thaneor2(~acer8@r167-61-81-127.dialup.adsl.anteldata.net.uy) has joined #tryton04:04
-!- thaneor3(~ldlc6@r167-61-81-127.dialup.adsl.anteldata.net.uy) has joined #tryton04:04
-!- springwurm(~Springwur@5.104.149.54) has joined #tryton06:04
-!- alidipatrick(~alidipatr@197.149.60.77) has joined #tryton07:04
-!- Timitos(~kpreisler@2001:a61:482:eb01:762b:62ff:fe84:ed7e) has joined #tryton07:04
-!- LordVan(~LordVAn@gentoo/developer/LordVan) has joined #tryton07:04
LordVanhi07:04
LordVanjust wondering .. if i want sorting to be case-insensitive .. is that a collation/DB issue or UI ?07:04
pokoliLordVan: if you want sorting to be case-insisentive you need to customize the order expression and use a lower() DB function08:04
LordVanpokoli, i suspected about as much. thanks.08:04
LordVanI was goin to customize it anyway ( for products to search case insensitive and LIKE '%term%' instead of the standard08:04
pokoliLordVan: The client uses the LIKE '%term%' pattern by default for char fields08:04
LordVanwell the product/variant search does not08:04
LordVanwhich is a bit inconvenient when adding articles to sale imho08:04
pokoliLordVan: the rec_name search? or what?08:04
pokoliLordVan: could you give me some example of what does not work?08:04
LordVango to sale, add sale line, go to product field and type search term08:04
-!- mrichez(~Maxime@2a02:a03f:c2e8:f900:ed77:85ea:af2b:ba6e) has joined #tryton08:04
LordVanit only works when it is from the first char08:04
LordVanlike a .startswith() search08:04
pokoliLordVan: this is the stanard behaviour for all code fields08:04
pokoliLordVan: https://bugs.tryton.org/issue734708:04
LordVanyes but doesn'T mean I find it convenient ^^08:04
pokoliLordVan: which is your use case?08:04
LordVanthe code has several different identifiers in it e.g. "ST37" "SJ235JR" "1.0037" - which are all effectively the same but different standards ,..08:04
LordVanand searching for either of them would be useful08:04
LordVan-- i have "standard" products for generic sheet metal parts08:04
LordVani mean sure i can search the specific field but since for me the standard case would be LIKE '%..%' i think i'l lchange it08:04
pokoliok, no specials reason, just your desire08:04
pokoliLordVan: if you add the identifiers on the product identifiers all be included on search by default08:04
LordVanyes i was thinking of something like that08:04
pokoliLordVan: and the product will be show if any of the identifiers match08:04
LordVani'D have to add new identifier types then .. nto sure if that is worth it tbh. just writing it in the code field works fine otherwise ;)08:04
-!- rpit(~rpit@p200300c88f0235001c42215a17f33f55.dip0.t-ipconnect.de) has joined #tryton08:04
pokoliLordVan: you can leave the type empty if the code is not validated08:04
LordVanpokoli, ah to be fair I haven't tested that .. it would be an option though08:04
LordVanthanks I shall consider08:04
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton09:04
-!- ludo2(~Thunderbi@2001:912:1480:380::1) has joined #tryton09:04
-!- acaubet(~Thunderbi@194.224.31.235) has joined #tryton09:04
-!- ludo2(~Thunderbi@2001:912:1480:380::1) has joined #tryton10:04
-!- LordVan(~LordVAn@gentoo/developer/LordVan) has joined #tryton12:04
-!- alidipatrick(~alidipatr@197.149.60.77) has joined #tryton12:04
-!- mariomop(~quassel@181.29.189.235) has joined #tryton13:04
-!- rpit(~rpit@p5b22b970.dip0.t-ipconnect.de) has joined #tryton13:04
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton14:04
-!- springwurm(~Springwur@5.104.149.54) has joined #tryton14:04
-!- alidipatrick(~alidipatr@197.149.60.77) has joined #tryton16:04
-!- thaneor(~ldlc6@r167-61-48-112.dialup.adsl.anteldata.net.uy) has joined #tryton16:04
-!- thaneor1(~acer8@r167-61-48-112.dialup.adsl.anteldata.net.uy) has joined #tryton16:04
-!- thaneor1(~acer8@r167-61-48-112.dialup.adsl.anteldata.net.uy) has joined #tryton17:04
-!- acaubet(~Thunderbi@194.224.31.235) has joined #tryton18:04
-!- ludo2(~Thunderbi@221.114.141.88.rev.sfr.net) has joined #tryton18:04
-!- alidipatrick(~alidipatr@197.149.60.77) has joined #tryton21:04
-!- rpit(~rpit@p200300c88f0235001c42215a17f33f55.dip0.t-ipconnect.de) has joined #tryton22:04
-!- lucascastro(~lucascast@177-185-133-170.dynamic.isotelco.net.br) has joined #tryton23:04

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