Hello,
I am looking for a way to constrain orders where a certain article appears in the order articles. But the filtered orders should be shown completely with all articles.
Example:
order 1
- Item_ID 5
- Item_ID 8
Order 2
- Item_ID 1
- Item_ID 10
Order 3
- Item_ID 8
- Item_ID 1
- Item_ID 10
Filter on Item_ID 8
Now only order 1 and 3 should be displayed. But these two orders then should be completely displayed with all artcicles.
A (simple) constrain on the Item_ID does not work, because all orders are still displayed, only the not matching items are suppressed.