[Solved] General question: How come I can do a partial search on name but not on a number?

Question

When I have created a search and I search, for example, by user, I can type just one letter and find all that contains that letter.
How come I can't search numbers in the same way?
eg. when I need user named "user", I can type in the search bar "us" and get the list
when I need ticket number 12345678, I can't type "123" and get a list, I have to type the full number out.
Is this a rule or is there a way around this?

Atchuthan - Technical Consultant, Sodexis Inc · Accepted Answer

@Siobhan,
You could change the filter_domain used in the SEARCH view.
<field name="ticket_number" string="Ticket number" filter_domain="[('ticket_number','ilike',self)]"/>

Andre de Kock · Answer

You can enable developer mode by clicking on the top right corner and then "About Odoo" and then "Activate Developer Mode". After that, as an example, you can click on Accounting -> Customers and view the Search View in the Debug menu.
In there you will find rules that define how searching is done on a certain object.

Siobhan · Answer

For this particular case as ticket number was not been used for arithmetic, I change it to a char and was able to do a search.

Related Posts	Відповіді	Переглядів
I can't find the error using search() Вирішено search odoo8	1 вер. 15	5934
Create a new 'group by' filter in a tree view search odoo8	1 бер. 15	9268
searchbar duplicate search searching searchbar odoo8	3 черв. 16	5025
How do I filter a spreadsheet pivot to the current/previous month search	1 лип. 25	1401
Search a message Вирішено search	1 лют. 25	1796

Це запитання позначене

Enjoying the discussion? Don't just read, join in!