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

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

search in two columns is not working in Odoo 12 CC

search odoo12

5 Vastaukset

4693 Näkymät

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

Tekijä Paras vastaus

@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

Tekijä

```

@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

Tekijä

still not working

Zbik

is possible testing _search and browse with sudo()?

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Search based on Many2many attachment file name filter search odoo12	0 jouluk. 21	2500
how i can Search on multi pal columns in Odoo 12CC ? Ratkaistu search multiple odoo12	3 kesäk. 19	4305
How do I filter a spreadsheet pivot to the current/previous month search	1 heinäk. 25	1423
Search a message Ratkaistu search	1 helmik. 25	1805
Odoo Mail Sending Limit Ratkaistu odoo12	2 jouluk. 23	16277

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!