Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

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

By
Siobhan
on 6/15/15, 4:50 AM 530 views

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?

2

Atchuthan - Technical Consultant, Sodexis Inc

--Atchuthan - Technical Consultant, Sodexis Inc--
3918
| 5 3 8
Puducherry, India
--Atchuthan - Technical Consultant, Sodexis Inc--
Passionate coder in Python/Odoo(formerly known as OpenERP).

Contact me via GMail: atchuthantu@gmail.com via Skype: atchuthan_skype
via Linkedin: http://in.linkedin.com/in/atchuthantu
Atchuthan - Technical Consultant, Sodexis Inc
On 6/16/15, 3:26 AM

@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)]"/>

2
Andre de Kock
On 6/15/15, 4:56 AM

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.



Thank you for this but I can't find any example on a search by a number. Checked the helpdesk module and it doesn't have this search function either

Siobhan
on 6/15/15, 5:02 AM
0
Siobhan
On 6/16/15, 1:50 AM

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. 

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 6/15/15, 4:50 AM
Seen: 530 times
Last updated: 6/16/15, 3:42 AM