My demo movie is available on my MendixMagic youtube channel (Youtube explanation)
You can also have a look at my portal on www.medixmagic.com
In the past I used a helper entity in which you can input the parameters to filter on the order. This enity can than be used as input on two microflows that retrieve the data from order and orderitem.
I assume you have a client entity and you want to filter based on the selected client. Create a helper entity with an association to the client entity. The tabcontainer should be included in the dataview of the helper.
I replicated based on below domain model:
The page will be something like this:
And with an on change event on the reference selector:
The DS_CreateHelper functie:
The Order retrieve as in tab 1:
And the orderitem retrieve:
If the client association is not filled in the helper it is a straight forward retrieve of all order and order items.
If the client association is filled the orderlist en orderitemlist must be based on the associations (see below on orderitem)
I have not done any testing, but think something like this should work…
You can even expand this by having a listening function to the OrderItem grid. When an orderitem is selected you give only the lines of the selected order. If help is needed I can supply an example.
Thanks a lot for the wonderful explanation, I will try this in my development branch and will get back to you :)