Skip to Content
This question has been flagged
1 Respondre
1714 Vistes
Avatar
Yohan Kuncoro

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 answering my question 

Avatar
Descartar
Avatar
Hoang Huy Hai
Best 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")&"'] ]")

 

Avatar
Descartar