Hi,

So first all you need is data from the database using aggregate and then use list filter action based on your requirement.

Thanks

.

Hello Sanjay Kumar Sahu,

You can achieve that by doing an Aggregate (without filters) and use the system server action ListFilter to get both filtered lists. In each table you can use the result of each ListFilter.

Hi EFreitas,

Thanks a lot for the answer. Even I was thinking of the same question. I have been using a bad practice by making 2 aggregates for it.

Regards,

Divyanshu

Good Question. Thanks for the answer EFreitas.

Hi Sanjay,

All good suggestions are already given.

Let me share another way you can achieve this.

• Create a Block with your TableWidget and its Aggregate. 
• Create an Input Parameter of type Boolean (for example Is<TableName1>) for your Block
• Create a conditioned filter (for table 1 and table 2) based on that Input Parameter inside your Aggregate.

Now you can put two instances of that Block on your screen, for table 1 you pass True to the Input of the Block and for table 2 you pass False.

Hope this helps!

Regards,

Nordin

Check the images bellow.

Get bookings list:

and after you can use it as the source of your table:

I created in a traditional web application, but you have ListFilter in server and client flows.

In a reactive application, you can filter the aggregate inside an action that is called OnAfterFetch (check the aggregate properties). Instead of using the result of ListFilter action, you can also "save" the result in 2 local variables (one for each table).

After lots of trial and error I finally figured it out. I used 2 ListFilters(one each for check-in and check-out) and 2 Output parameters and mapped output parameters source to ListFilters output. It worked fine.

Thanks All for your helps.