Cédric Krier pushed to branch branch/default at Tryton / Tryton


Commits:
2ecc50ec by Cédric Krier at 2024-06-18T20:29:31+02:00
Reuse simple COALESCE expression to filter moves after stock period

The expression must be the same as the one in the indexes such that the
indexes can be used to directly filter out all the moves before the period.
This restores the original expression that was changed by e4431b79e409 for the
generic move_date. But by design there can not be any assigned move planned
before the closed period.
- - - - -
32bdc030 by Cédric Krier at 2024-06-18T20:32:09+02:00
Do not add period query to the union if there is no period

There is no cache record without period so there is no need to add the query
to the UNION.
- - - - -
1b4d72bf by Cédric Krier at 2024-06-18T20:33:41+02:00
Add company to the stock move indexes

Almost all the queries on stock move filter by company.
- - - - -
f06bb8b3 by Cédric Krier at 2024-06-19T12:44:33+02:00
Add location and use product range in stock period cache index

The cache is always filtered by location and the product is often filtered
with reduced ids.
- - - - -
ee8f075a by Cédric Krier at 2024-06-19T13:23:57+02:00
Set product range index last for stock move

As product clause are reduced ids, they have less chance to be usable than the
date which is often a single value.
- - - - -


2 changed files:

- modules/stock/move.py
- modules/stock/period.py


View it on Heptapod: 
https://foss.heptapod.net/tryton/tryton/-/compare/d671e177ab660208812bc96bfd8bc366f85b2012...ee8f075af4861a4ad0c848ca2ab0b0aa49df5674

-- 
View it on Heptapod: 
https://foss.heptapod.net/tryton/tryton/-/compare/d671e177ab660208812bc96bfd8bc366f85b2012...ee8f075af4861a4ad0c848ca2ab0b0aa49df5674
You're receiving this email because of your account on foss.heptapod.net.


Reply via email to