[tryton-commits] changeset in modules/stock:6.0 Use left join on currency rate fo...

[Maxime Richez]

changeset 2ae8fe7d3e0f in modules/stock:6.0
details: https://hg.tryton.org/modules/stock?cmd=changeset&node=2ae8fe7d3e0f
description:
        Use left join on currency rate for margin report

        issue11711
        review421731003
        (grafted from becc2c65395d0c24505854abfbdb481fa84a9c5b)
diffstat:

 stock_reporting_margin.py |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r b053f51384fd -r 2ae8fe7d3e0f stock_reporting_margin.py
--- a/stock_reporting_margin.py Tue Sep 13 23:47:14 2022 +0200
+++ b/stock_reporting_margin.py Wed Sep 28 09:47:03 2022 +0200
@@ -89,7 +89,7 @@
             query=Currency.currency_rate_sql())
 
         from_item = (move
-            .join(currency_rate,
+            .join(currency_rate, type_='LEFT',
                 condition=(move.currency == currency_rate.currency)
                 & (currency_rate.start_date <= move.effective_date)
                 & ((currency_rate.end_date == Null)