Our company has 4 Regions and under each Region there are multiple Districts. I have a repeating field for Region (in case all 4 are selected) and I have a portal which should display all the Districts in the Region(s) selected.
I am using an ExecuteSQL statement to filter my portal records to show only those specified Districts and in the Data Viewer it shows the correct result of my SQL statement. When I put this SQL statement in the Filter Portal Records, it only shows me the Districts under Region 1. It doesn't matter what Region I select or how many I select, it only ever shows me the Districts under Region 1.
Has anyone come across this situation before? Below is an example of my SQL statement, the expected results and the portal of the incorrect results.