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.