Startswith and endswith domain filter in openerp7

Question

Hi,

I know that the below are supported operators by openerp7.

  =, !=, >, >=, <, <=, like, ilike, in, not in, child_of, parent_left, parent_right

I would like to implement startswith and endswith search in openerp. Ex

AB* (starts with AB)
*AB (Ends with AB)

Is there a way to do it with the openerp framework itself without executing them as sql statements with cr.execute(). Specifically i would like to do that in global filter.

Thanks for your insights.

Mohammad Alhashash · Accepted Answer

Use '=like' and '=ilike' operators.

starts with AB is [('field','=like','AB%')]

ends with AB is [('field','=like','%AB')]

Use ilike for case insensitive match.

like and ilike operators (without '=') automatically add wildcard before and after search value.

Powiązane posty	Odpowiedzi	Widoki
how can i create a filter that uses the "and" condition filter search	2 lis 23	3181
How to save a filter with today value from context Rozwiązane filter search	7 kwi 21	20558
filter with related model field Rozwiązane filter search	1 paź 20	4927
change search filter Rozwiązane filter search	2 lis 16	4277
Search with functional fields Rozwiązane filter search	4 mar 15	21171

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!