[BOM] Empty fields for 'order cycle' if order cycle closed more than ~90 days ago

[drummer83]

Description

All line items of an order cycle which ended more than ~90 days ago show an empty 'order cycle' field. This is independent from permissions.

Expected Behavior

The order cycle field should display the order cycle of the order/line item.

Actual Behaviour

All line items of an order cycle which ended more than ~90 days ago show an empty 'order cycle' field.

Steps to Reproduce

1. Make sure you have an order cycle with orders.
2. Set the end date of the order cycle more than 90 days in the past.
3. Visit page /admin/orders/bulk_management.
4. Look at the column 'order cycle'

Animated Gif/Screenshot

Order cycle settings:

BOM results:

Workaround

Severity

Rating this as s5, because I assume most users are working with current order cycles, which are not 3 months in the past. Please adjust if you think it makes sense.
bug-s5: we can live with it, only a few users impacted

Your Environment

• Version used: v4.2.31
• Browser name and version:
• Operating System and version (desktop or mobile):

Possible Fix

[RachL]

@drummer83 FYI currently we can't reach really old OC, probably related to performance problems. See #4544

It could be linked.

[abdellani]

@RachL

No, this is a different problem.

On this page, the order cycles and the orders are fetched from the backend using different queries.
The query, used for the order cycles, fetches only those that are closed in less than 3 months.