<h1>base<em>phone</em>search</h1> <p>Provides the method search<em>phone</em>fuzzy() for res.partner.</p> <pre><code>This method will search the &#39;phone&#39; and &#39;mobile&#39; fields of res.partner for the given phone number. It will by default ignore all non digit characters and will search from right to left. e.g.: &#39;+43 (0)660 1234 - 567 &#39; will be converted to &#39;7654321066034&#39; When we search for a phone number by self.env[&#39;res.partner&#39;].search_phone_fuzzy(&#39;(0)660 12 34 567&#39;) we search for 1.) Search for partner where &#39;phone&#39; or &#39;mobile&#39; ends with &#39;234567&#39; 2.) Use the phonenumbers Python Library to further narrow down the results 3.) Return an record set with the found partner </code></pre> <h2>Database search optimization</h2> <pre><code># SELECT reverse(regexp_replace(regexp_replace(&#39;0043 (0) 3160 123-45-67 &#39;, &#39;[^0-9]&#39;, &#39;&#39;, &#39;g&#39;), &#39;00*&#39;, &#39;&#39;)) # CREATE OR REPLACE FUNCTION phone_clean_reverse(text) RETURNS text AS $$ # SELECT concat(left(reverse(regexp_replace(regexp_replace($1, &#39;[^0-9]&#39;, &#39;&#39;, &#39;g&#39;), &#39;^000*&#39;, &#39;&#39;)), 6)); # $$ LANGUAGE &#39;sql&#39; IMMUTABLE STRICT; # # DROP INDEX idx_phone_reverse; # CREATE INDEX idx_phone_reverse ON res_partner(phone_clean_reverse(phone)); # # DROP INDEX idx_mobile_reverse; # CREATE INDEX idx_mobile_reverse ON res_partner(phone_clean_reverse(mobile)); # # select &quot;id&quot;, firstname, lastname, phone # from res_partner # where phone_clean_reverse(phone) = phone_clean_reverse(&#39;+43 (0) 7478-327&#39;); # # select &quot;id&quot;, firstname, lastname, mobile # from res_partner # where phone_clean_reverse(mobile) = phone_clean_reverse(&#39;+43 (0) 7478-327&#39;); # # select &quot;id&quot;, firstname, lastname, phone, mobile # from res_partner # where phone_clean_reverse(mobile) = phone_clean_reverse(&#39;+43 (0) 7478-327&#39;) # or phone_clean_reverse(phone) = phone_clean_reverse(&#39;+43 (0) 7478-327&#39;); </code></pre>