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

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

How to search product by field in different table

search name_search

7 الردود

8491 أدوات العرض

Mostafa Alaa

i want to use name_search in product to get product by search the lot name which in stock.production.lot

class ProductProduct(models.Model):
    _inherit = 'product.product'

    @api.model
    def name_search(self, name='', args=None, operator='ilike', limit=100):

            args = args or []
            print('arg ',args)

            recs = self.search([('lot_name', operator, name)]  args, limit=limit) #stock_quant_ids.lot_id.name
            print('recs ', recs)
            if not recs.ids:
                return super(ProductProduct, self).name_search(name=name, args=args,
                                                           operator=operator,
                                                           limit=limit)
            return recs.name_get()

Sehrish

When should you use name_search method: https://goo.gl/7PHhPP

Mostafa Alaa

الكاتب أفضل إجابة

from odoo.osv import expression

class ProductProduct(models.Model):

_inherit = 'product.product'

lot = fields.Char()

@api.model

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

""" search for product using the Lot number """

self.lot = name

print (self.lot)

args = args or []

recs = None

# only perform search by when the name is passed

if name:

# don't use limit here

recs = self.env['stock.production.lot'].search([('barcode', operator, name)])

if recs:

# handle extra filter that was passed by the domain attribute in the XML

args = expression.AND([args, [('id', 'in', recs.mapped('product_id').ids)]])

return self.search(args, limit=limit).name_get()

# no Lot was founded may be the user meant to search by product name

return super(ProductProduct, self).name_search(name=name,

args=args,

operator=operator,

limit=limit)

Paresh Wagh

Hi Mostafa: I haven't looked at the logic but going purely by the syntax, if you put a env['stock.production.lot'] after self like so it should work.

self.env['stock.production.lot'].search([('lot_name', operator, name)]

Mostafa Alaa

الكاتب

raise ValueError("Invalid field %r in leaf %r" % (left, str(leaf)))

ValueError: Invalid field u'type' in leaf "<osv.ExtendedLeaf: (u'type', u'=', u'product') on stock_production_lot (ctx: )>"

Paresh Wagh

You typically get this error when the domain condition is not correct. Is it possible to post the section of the custom code you have written ?

Mostafa Alaa

الكاتب

recs = self.env['stock.production.lot'].search([('name', operator, name)] +args, limit = limit)

Paresh Wagh

Check the run-time value of operator, name, args and limit when this gets executed.

Mostafa Alaa

الكاتب

thanks i found the solution

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
How do I filter a spreadsheet pivot to the current/previous month search	1 يوليو 25	1397
Search a message تم الحل search	1 فبراير 25	1792
Disable Instant Search on /shop search	0 سبتمبر 23	2699
User search operators search	2 يونيو 23	4783
How to search On Many2Many field ? search	1 أغسطس 22	13468

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!