Datagrid column value Calculation from two different selected Parent entity.
Hi, I have following type of entity relation. There is requirement that, User will select module → Base . After that User will select another module and then Base. Final datagrid should contain UseCases which are common to both selected Base and comparison column should contain difference of Time of Matched Usecases. I am currently using “Listen To Widget” property to display hierarchy but facing problem in APPROACH to calculate difference . How shall I proceed ? Do I need to Change database structure ?
From the selection of the 2 base entities you'll have all the use cases available. In a microflow find the common use cases and generate the difference data in a separate entity that you display.
This can be easily achieved by using a microflow as datasource for a grid.