I’m trying to filter by a Text field and I have set search_full_text to False. Searching/Filtering by a Text field not working good at all (#12328) · Issues · Tryton / Tryton · GitLab.
The problem that I have now is that when I search for a Text field that has break lines in it, for example:
ITEM 1: 1242W LIGHT BULB + PHOTO
OPERATING AT 12V (XVSB)
VERSATILE 0" ADJUSTABLE HOLDER
And I search these two lines (1st and 2nd line) for example like these 2 ways:
Variants.Description: "ITEM 1: 1242W LIGHT BULB + PHOTO OPERATING AT 12V (XVSB) "
Variants.Description: “1242W + PHOTO AT 12V”
It doesn’t find the record. If search_full_text is True (default), it finds the record.
So there is some way to keep the search_full_text to False and not having any problems with text fields that have breaklines.