Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

search in two columns is not working in Odoo 12 CC

search odoo12

5 Odpowiedzi

4677 Widoki

Usman Farzand

```

@api.multi

def name_get(self):

result = []

for record in self:

name = record.name + ' - ' + str(record.id_proof_no)

result.append((record.id, name))

return result

```

working fine

for example

ABC - 3333333333

result in search ABC is fine but when i put 33333333 its not come on search

what i done

````

@api.model

def _name_search(self, name, args=None, operator='ilike', limit=100, name_get_uid=None):

if operator in ('ilike', 'like', '=', '=like', '=ilike'):

args = expression.AND([ args or [], ['|', ('visitor.id_proof_no', operator, name), ('visitor', operator, name)] ])

return super(VisitDetails, self)._name_search(name, args=args, operator=operator, limit=limit, name_get_uid=name_get_uid)

```

its not working where i'm wrong pls correct me

Usman Farzand

Autor Najlepsza odpowiedź

@api.multi
def name_get(self):
result = []
for prod in self:
result.append((prod.id, "%s - %s" % ( prod.name, prod.id_proof_no or '')))
return result

@api.model
def _name_search(self, name, args=None, operator='ilike', limit=100, name_get_uid=None):
args = args or []
if operator == 'ilike' and not (name or '').strip():
domain = []
else:
domain = ['|', ('name', 'ilike', name), ('id_proof_no', 'ilike', name)]
sat_code_ids = self._search(expression.AND([domain, args]), limit=limit, access_rights_uid=name_get_uid)
return self.browse(sat_code_ids).name_get()

Zbik

1. Why you inherit _name_search (private method) and not name_search?

2. See this part of code in models.py _name_search:

if not self._rec_name:
_logger.warning("Cannot execute name_search, no _rec_name defined on %s", self._name)
elif not (name == '' and operator == 'ilike'):
args += [(self._rec_name, operator, name)]

UPDATED:

Simmilar solution in account_invoice.py:

@api.model
def _name_search(self, name, args=None, operator='ilike', limit=100, name_get_uid=None):
  args = args or []
  invoice_ids = []
  if name:
    invoice_ids = self._search([('number', '=', name)] + args, limit=limit, access_rights_uid=name_get_uid)
  if not invoice_ids:
   invoice_ids = self._search([('name', operator, name)] + args, limit=limit, access_rights_uid=name_get_uid)
  return self.browse(invoice_ids).name_get()

Usman Farzand

Autor

```

@api.multi

def name_get(self):

result = []

for record in self:

name = record.name + ' - ' + str(record.id_proof_no)

result.append((record.id, name))

return result

@api.model

def _name_search(self, name, args=None, operator='ilike', limit=100, name_get_uid=None):

args = args or []

if operator == 'ilike' and not (name or '').strip():

domain = []

else:

domain = ['|', ('name', 'ilike', name), ('id_proof_no', 'ilike', name)]

sat_code_ids = self._search(expression.AND([domain, args]), limit=limit, access_rights_uid=name_get_uid)

return self.browse(sat_code_ids).name_get()

```

Usman Farzand

Autor

still not working

Zbik

is possible testing _search and browse with sudo()?

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

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Search based on Many2many attachment file name filter search odoo12	0 gru 21	2486
how i can Search on multi pal columns in Odoo 12CC ? Rozwiązane search multiple odoo12	3 cze 19	4282
How do I filter a spreadsheet pivot to the current/previous month search	1 lip 25	1385
Search a message Rozwiązane search	1 lut 25	1791
Odoo Mail Sending Limit Rozwiązane odoo12	2 gru 23	16225

To pytanie dostało ostrzeżenie

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