Community mailing list archives

community@mail.odoo.com

Re: SQL Stock

by
Giovanni Francesco Capalbo
- 10/10/2016 03:31:46
Those are non stored computed fields. You cannot do that.

https://github.com/OCA/OCB/blob/10.0/addons/stock/models/product.py#L27


the default for computed fields is not stored. therefore the data you
search for in your sq DB does not exist.

On 10/10/16 05:57, Soragan Ong wrote:
> Hi,
> 
> We are looking to directly pull stock information from the odoo database. Does anyone know what’s the SQL query to get the forecast stock and on hand stock? Thank you.
> 
> 
> Best Regards
> Soragan
> 
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-59
> Post to: mailto:community@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe
> 

-- 
Giovanni Francesco Capalbo - Ontwerp en implementatie

Therp - Maatwerk in open ontwikkeling

mail: giovanni@therp.nl
tel:  020 3093093
web: http://therp.nl