First, I know that having Text fields in a list view is expensive on resources. But if the users want it, I wouldn’t complain because they have to work with the system.
The field we are talking about is defined as Text field on
description = fields.Text('Description')
In this case the user wants to search for a very specific rare spare part. This part is not added as a regular product in Tryton, because it’s very rare so a general product is used for this. When adding to a sale, the description on the sale line is modified as well as the price etc.
When using the GTK client (5.0.11) the user opens a list with sale lines and opens the search / filter window. Then in the
description field he adds two words. After clicking on
Find, in the search bar the two words appear surrounded by quotes:
Description: "accu DDF"
Tryton does not find any record. However removing the quotes:
Description: accu DDF
Tryton finds all the records with the words “accu” and “DDF” in the description. It doesn’t matter where these words are in the description. This is the expected behavior.
Also, the latter does not work for Char fields. So what should be the default behavior? IMO when you want to search in Char or Text fields:
- Just enter some words for a field and Tryton will search for records where those words appear in
- Enter some wildcards to search for portions of some words
What can we do about this?