oe_browse() function

Question

Hi, im trying to build up some report using google sheet as i know we can use filtering in oe_browse function but can we take the filtering value from google sheet cell ? let say the value on A1 ? i use below syntax

oe_browse("purchase.order";"id name x_studio_type date_approve partner_id amount_untaxed amount_total product_id";"[['x_studio_type', '=', 'A1'],['x_studio_type', '!=', false]]")

my 2nd question can we make filter on range ? let say date between A1 and B2 column
Thank you for answe

Hoang Huy Hai · Answer

It ok. Try  :

oe_browse("purchase.order";"id name x_studio_type date_approve partner_id amount_untaxed amount_total product_id";"[['x_studio_type', '=', '"&A1&"'],['x_studio_type', '!=', false]]")

2nd question : it ok , try :

oe_browse("purchase.order";"id name x_studio_type date_approve partner_id amount_untaxed amount_total product_id";"[['date', '>=', '"&text(A1;"yyyy-mm-dd")&"'],
['date', '<=', '"&text(B2;"yyyy-mm-dd")&"']
]")

Tämä kysymys on merkitty

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