콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
2643 화면

A customer wants to be able to search for money values using both . and ,  as decimal separators (because we live in a country where , is official separator but . also is often (unofficially) used).


I started with the following filter:

<field name="offer_amount" string="Sum of Quotation" filter_domain="[('offer_amount', 'ilike', self)]"/>


It works for search values with ., such as 14.7

To make it work also for , I would need to sanitize the search value for this field using something like str.replace(',', '.')


I tried

<field name="offer_amount" string="Sum of Quotation" filter_domain="[('offer_amount', 'ilike', str(self).replace('',,'.'))]"/>

but got an error because filter_domain is parsed inside Javascrypt py.js library which doesn't support replace().

What is the right way to transform search values for specific fields?

아바타
취소
관련 게시물 답글 화면 활동
1
9월 23
1246
1
11월 21
4449
1
10월 20
4577
1
5월 24
4653
3
3월 24
1461