Hi Community!
I am developing a simple web experience and I hit some obstacles with the filter widget... In short, I want to add a group filter with a dropdown list showing all the values, but the dropdown list only shows the unique value of one of the layers (the layer and its field that is selected as the main field). How do I include all the unique values across all the layers?
In our web experience, we have 6 point layers that need filtering. The 6 layers all contain a field called rating. The rating ranges from Not Rated (NR), A+, A, A-, all the way to F.
Layer 1 contain (NR, A+, A, A-, B+, B) only;
Layer 2 contains (A+, A, A-, B+, B, B-, C+, C, C-, D-, F) only;
Layer 3 contains (A+, A, B-, C+, F) only;
Layer 4 contains (NR) only;
Layer 5 contains (NR) only;
Layer 6 contains (NR) only;
I configured the filter widget this way: I added a group filter by choosing "New Group", and added all the 6 layers in "Data". In the SQL Expression Builder, I selected Layer 1, and the Rating field as the main field. I selected the "Ask for value" option, and selected "Dropdown list" in the choose input style section.
As a result of the above configuration, I have something that is very close to what I want - except it only shows the unique values of Layer 1 (NR, A+, A, A-, B+, B) only. It cannot filter for values that Layer 1 do not have. For example, it cannot filter for some values of Layer 2 (B-, C+, C, C-, D-, F).
How do I include all the unique values across all the 6 layers? (or even better, include all the unique values plus the ones that doesn't exist in the data right now as well, i.e. D+ and D in this case?)
I took a look at the Unique (predefined) option, but it doesn't seem like I can add value that is not in the layer/field selected as main field.
(I know that there is a Custom Filter that one can add to a web experience, but my supervisor mentioned we want to keep the filter widget less complicated, so it won't overwhelm our clients, so that is a last resort.)
