This question has been flagged
2 Replies
6148 Views

hi,

i have one model called "product" 

product

fields : title,description,timestamp

now i want to pass timestamp as a kw in route  and access  them in controller and pass in query of product and get product objects and pass them in template in odoo 10

url:  /product/101233.00/

so it search product record for timestamp of 101233.00  in odoo and return product object 

Avatar
Discard

plz clarify your question that what you want to do?

Best Answer

Please find here an example that should help you...


@http.route('/product/<field>/<value>', type='http', auth="public", website=True) 
def get_product_by_name(self, field, value, **kw):
        assert field in ('name', 'description_sale', 'create_date')
        prod = request.env['product.product'].search([(field, 'ilike', value)])
        if prod:
            return json.dumps(prod.read(['name', 'create_date', 'description_sale']))
        else:
            return "Product not found"


    # http://127.0.0.3:8069/product/create_date/2017-02-16 16:48

        => will return products create at "2017-02-16 16:48"

    # http://127.0.0.3:8069/product/name/ipod

        => will return products with "ipod" in name

    # http://127.0.0.3:8069/product/description_sale/wifi

        => will return products with "wifi" in the description

Avatar
Discard
Author

thanks a lot its work