Issue 11682

Title
Left strip wildcard for search code only for full text operand
Priority
feature
Status
resolved
Nosy list
ced, herrdeh, reviewbot, roundup-bot
Assigned to
ced
Keywords
review

Created on 2022-09-01.07:12:47 by herrdeh, last changed 2 months ago by roundup-bot.

Messages

New changeset 0297599b53c3 by Cédric Krier in branch 'default':
Strip only one wildcard
https://hg.tryton.org/tryton-env/rev/0297599b53c3

New changeset b8c89f5cc660 by Cédric Krier in branch 'default':
Left strip code operand only when it is a full text
https://hg.tryton.org/tryton-env/rev/b8c89f5cc660
New changeset 65b62a8b02c3 by Cédric Krier in branch 'default':
Strip only one wildcard
https://hg.tryton.org/trytond/rev/65b62a8b02c3
New changeset ee18cb647324 by Cédric Krier in branch 'default':
Strip only one wildcard
https://hg.tryton.org/tryton/rev/ee18cb647324
New changeset f6d3baace8db by Cédric Krier in branch 'default':
Strip only one wildcard
https://hg.tryton.org/sao/rev/f6d3baace8db
New changeset 3a9d487cdf99 by Cédric Krier in branch 'default':
Left strip code operand only when it is a full text
https://hg.tryton.org/modules/sale_product_customer/rev/3a9d487cdf99
New changeset 44c68ce98e8e by Cédric Krier in branch 'default':
Left strip code operand only when it is a full text
https://hg.tryton.org/modules/purchase/rev/44c68ce98e8e
New changeset a905de74ea98 by Cédric Krier in branch 'default':
Left strip code operand only when it is a full text
https://hg.tryton.org/modules/product/rev/a905de74ea98
New changeset 76099fe283b7 by Cédric Krier in branch 'default':
Left strip code operand only when it is a full text
https://hg.tryton.org/modules/party/rev/76099fe283b7
New changeset 43d48a6670b4 by Cédric Krier in branch 'default':
Left strip code operand only when it is a full text
https://hg.tryton.org/modules/country/rev/43d48a6670b4
New changeset 5e597f2264ed by Cédric Krier in branch 'default':
Left strip code operand only when it is a full text
https://hg.tryton.org/modules/bank/rev/5e597f2264ed
New changeset ab59016bfe86 by Cédric Krier in branch 'default':
Left strip code operand only when it is a full text
https://hg.tryton.org/modules/analytic_account/rev/ab59016bfe86
New changeset e455de0a2feb by Cédric Krier in branch 'default':
Left strip code operand only when it is a full text
https://hg.tryton.org/modules/account_payment_sepa/rev/e455de0a2feb
New changeset ffedd8c5b4cc by Cédric Krier in branch 'default':
Left strip code operand only when it is a full text
https://hg.tryton.org/modules/account/rev/ffedd8c5b4cc
Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2022-09-02.15:16:03

Indeed we could only strip the wildcard for full text operand (%<string>%) so it will allow to surround the searched value by %% to have a full text search on code.

Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2022-09-01.08:15:54

We are not reverting issue7347. If you want to search on product code, make a query on the product code.

Author: [hidden] (herrdeh)
Date: 2022-09-01.07:12:46

Product numbers often are combined as of "prefix123456" - eg "iso9023", "DIN55", "res220", "screw5x20" etc.

The present search algo would not find if I just search for the number, but I think it should. So we should use a "find any occurance of sequence within a string" algo instead.

https://discuss.tryton.org/t/search-part-of-string-found-not-whole-string/5505

History
Date User Action Args
2022-09-16 23:39:26roundup-botsetmessages: + msg78193
2022-09-16 23:39:19roundup-botsetmessages: + msg78192
2022-09-16 23:39:15roundup-botsetmessages: + msg78191
2022-09-16 23:39:13roundup-botsetmessages: + msg78190
2022-09-16 23:39:06roundup-botsetmessages: + msg78189
2022-09-16 23:38:56roundup-botsetmessages: + msg78188
2022-09-16 23:38:50roundup-botsetmessages: + msg78187
2022-09-16 23:38:38roundup-botsetmessages: + msg78186
2022-09-16 23:38:35roundup-botsetmessages: + msg78185
2022-09-16 23:38:30roundup-botsetmessages: + msg78184

Showing 10 items. Show all history (warning: this could be VERY long)