Hello Appsheet community,
I want to have a dashboard with one map view and an additional detail view that acts as a filter for the map view.
Therefore I created two slices: one for the map view and another for the filter table.
The filter table consist of multiple columns, which are all of type EnumList with base type Ref.
For this table, there is only one row for the whole table, and you can only edit this row.
The data slice for the map has a row filter condition, so that only points should be displayed that match the data in the filter table.
The row filter condition is: IN([REC_LOC_ID],LOOKUP(“85n2043”,“Maps_Filter_Slice”,“MAP_ID”,“MAP_LOC_ID”))
This is just a filter for one of the columns (LOC_ID), which is meant to be used as a pattern for all other columns, as soon as it works. It should filter out all rows, where the REC_LOC_ID of the data slice is not in the EnumList of the filter table in column MAP_LOC_ID. The key column of the filter table is MAP_ID. Since there is only one row with the key “85n2043”, it should return one list.
I already tried several other expressions/approaches (SELECT, FILTER, INDEX, …), but nothing worked yet.
The problem is, as soon as I have more than one entry in the EnumList of the filter table, it only shows points on the map for one of them, not for both. Even more confusing is, that in the results pane for the row filter condition, it shows the correct results.
In this example, the blue marked column is for the LOC_ID, and there are two entries in the filter table (3, 108). In the results pane, as marked in green, all rows are indicated true that have a LOC_ID of 3 or 108. Unfortunately, this is not reflected in the map view and I have no idea why.
As you can see in the last screenshot, the green marked points are displayed for the one filter entry (Wismar, Rothentor). In the red area, the points for the other filter entry (Mittenwald, Am Horn) are missing.
Any help would be appreciated.