Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below scenario and would like to get suggestions on data modeling
Message Table:
Train Table:
I need to apply section access on Terminal and display all messages (both related to train and unrelated) on the same screen with common filters. When I apply section access to the terminal, all the rows in the Message table that are not related to train become unavailable, which I believe is expected behavior.
What could be correct approach to achieve this?
or ignore selection thru set analysis
When section access is applied, it filters out data based on user permissions when the app is opened. So I believe , alternate states or set analysis cannot be applied to data that is not available due to these restrictions.It will require a change at the data model level. Currently, I set the value of null TrainID to 'NA' in the message table and append a dummy row with 'NA' in the Train table. I then update section access to grant all users access to this dummy data row.I would like to understand a better approach.
I think you have already applied the best approach by replacing the NULL with a real value within this KEY field.