| chat.freenode.net #tryton log beginning Thu Apr 8 12:00:01 AM CEST 2021 | ||
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 22:17 | |
| -!- srgdts_(~srgdts@unaffiliated/srgdts) has joined #tryton | 01:49 | |
| -!- thaneor2(~acer8@r167-61-81-127.dialup.adsl.anteldata.net.uy) has joined #tryton | 02:27 | |
| -!- thaneor3(~ldlc6@r167-61-81-127.dialup.adsl.anteldata.net.uy) has joined #tryton | 02:28 | |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 04:50 | |
| -!- alidipatrick(~alidipatr@197.149.60.77) has joined #tryton | 05:15 | |
| -!- Timitos(~kpreisler@2001:a61:482:eb01:762b:62ff:fe84:ed7e) has joined #tryton | 05:54 | |
| -!- LordVan(~LordVAn@gentoo/developer/LordVan) has joined #tryton | 05:56 | |
| LordVan | hi | 05:56 |
|---|---|---|
| LordVan | just wondering .. if i want sorting to be case-insensitive .. is that a collation/DB issue or UI ? | 05:57 |
| pokoli | LordVan: if you want sorting to be case-insisentive you need to customize the order expression and use a lower() DB function | 06:02 |
| LordVan | pokoli, i suspected about as much. thanks. | 06:03 |
| LordVan | I was goin to customize it anyway ( for products to search case insensitive and LIKE '%term%' instead of the standard | 06:04 |
| pokoli | LordVan: The client uses the LIKE '%term%' pattern by default for char fields | 06:06 |
| LordVan | well the product/variant search does not | 06:08 |
| LordVan | which is a bit inconvenient when adding articles to sale imho | 06:08 |
| pokoli | LordVan: the rec_name search? or what? | 06:08 |
| pokoli | LordVan: could you give me some example of what does not work? | 06:09 |
| LordVan | go to sale, add sale line, go to product field and type search term | 06:09 |
| -!- mrichez(~Maxime@2a02:a03f:c2e8:f900:ed77:85ea:af2b:ba6e) has joined #tryton | 06:09 | |
| LordVan | it only works when it is from the first char | 06:09 |
| LordVan | like a .startswith() search | 06:10 |
| pokoli | LordVan: this is the stanard behaviour for all code fields | 06:12 |
| pokoli | LordVan: https://bugs.tryton.org/issue7347 | 06:12 |
| LordVan | yes but doesn'T mean I find it convenient ^^ | 06:14 |
| pokoli | LordVan: which is your use case? | 06:14 |
| LordVan | the code has several different identifiers in it e.g. "ST37" "SJ235JR" "1.0037" - which are all effectively the same but different standards ,.. | 06:15 |
| LordVan | and searching for either of them would be useful | 06:16 |
| LordVan | -- i have "standard" products for generic sheet metal parts | 06:16 |
| LordVan | i mean sure i can search the specific field but since for me the standard case would be LIKE '%..%' i think i'l lchange it | 06:17 |
| pokoli | ok, no specials reason, just your desire | 06:19 |
| pokoli | LordVan: if you add the identifiers on the product identifiers all be included on search by default | 06:19 |
| LordVan | yes i was thinking of something like that | 06:20 |
| pokoli | LordVan: and the product will be show if any of the identifiers match | 06:20 |
| LordVan | i'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 ;) | 06:21 |
| -!- rpit(~rpit@p200300c88f0235001c42215a17f33f55.dip0.t-ipconnect.de) has joined #tryton | 06:22 | |
| pokoli | LordVan: you can leave the type empty if the code is not validated | 06:50 |
| LordVan | pokoli, ah to be fair I haven't tested that .. it would be an option though | 06:50 |
| LordVan | thanks I shall consider | 06:51 |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 07:08 | |
| -!- ludo2(~Thunderbi@2001:912:1480:380::1) has joined #tryton | 07:18 | |
| -!- acaubet(~Thunderbi@194.224.31.235) has joined #tryton | 07:23 | |
| -!- ludo2(~Thunderbi@2001:912:1480:380::1) has joined #tryton | 08:12 | |
| -!- LordVan(~LordVAn@gentoo/developer/LordVan) has joined #tryton | 10:04 | |
| -!- alidipatrick(~alidipatr@197.149.60.77) has joined #tryton | 10:51 | |
| -!- mariomop(~quassel@181.29.189.235) has joined #tryton | 11:05 | |
| -!- rpit(~rpit@p5b22b970.dip0.t-ipconnect.de) has joined #tryton | 11:54 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 12:00 | |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 12:07 | |
| -!- alidipatrick(~alidipatr@197.149.60.77) has joined #tryton | 14:28 | |
| -!- thaneor(~ldlc6@r167-61-48-112.dialup.adsl.anteldata.net.uy) has joined #tryton | 14:29 | |
| -!- thaneor1(~acer8@r167-61-48-112.dialup.adsl.anteldata.net.uy) has joined #tryton | 14:30 | |
| -!- thaneor1(~acer8@r167-61-48-112.dialup.adsl.anteldata.net.uy) has joined #tryton | 15:00 | |
| -!- acaubet(~Thunderbi@194.224.31.235) has joined #tryton | 16:12 | |
| -!- ludo2(~Thunderbi@221.114.141.88.rev.sfr.net) has joined #tryton | 16:54 | |
| -!- alidipatrick(~alidipatr@197.149.60.77) has joined #tryton | 19:07 | |
| -!- rpit(~rpit@p200300c88f0235001c42215a17f33f55.dip0.t-ipconnect.de) has joined #tryton | 20:33 | |
| -!- lucascastro(~lucascast@177-185-133-170.dynamic.isotelco.net.br) has joined #tryton | 21:39 | |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!