Page selections and synchronization
So I have a Region List (R1) and project list (R2) rolling up to these Regions. Within R1, we identify special regions using a boolean line item in a separate module.
I have a NUX page where all the attributes of only the 'special regions' that is R1 filtered with the above line item, dsiplayed for the end user to review. Within this I also have a grid table which displays the projects (R2) and some attributes pertaining to these projects, set up with synchronized hierarchy selection. For example, If I select a special region from the grid on the top (R1 list with special region boolean filter), projects that roll up to these regions display in the second grid with its respective attributes.
PROBLEM: Since R1 as a list has two sets of data within, that is special region and non-special region, in this particular NUX report i wish to see only special region and its respective projects. So i would like to create another filter that only shows projects of the special region and not all region. Problem however is on the sync selection, say for example i select a special region and if the special region does not have a project under it, the table that displays the projects shows the previous selection of special region instead of empty. I wish to acheive the latter so if there is NO projects under a special region, just display empty table.
Note: I know that this works properly in standalone basis that is if the report grid 1 has only special region for the users to select, then grid 2 would automatically only shows projects based on grid 1 selection. However, problem is there are other pages/reports where users have access to entire R1 list and/or R1 list filtered with non-special region, so when user navigates back into the report with R1 (special region filter) and projects grid the latter's automatically syncing with R1 (non special region) which could lead to confusion in the reading of the data if the user doesnt reselect in the page.