How to sync table filters in Apps table-element?

Apps (Frontend) Apps Builder
1

Hi all,
when I apply a filter to a column in a regular table element in my app and want to filter another column, the shown values are not synced with the first applied filter, i.e., I quickly end up in empty sets because the combinations I selected are not valid.
Can I configure this sync somehow without using additional filter elements?

1 Like
2

Maybe this explanation helps to at least move forward and find the fitting setup for your scenario.

image
image1917Ă—964 149 KB

1 Like
3

for future readers, all columns of the table must be added to the “joins” section:

{
  "id": "syncSet_procurement_report",
  "sources": [
    "data_procurement_report"
  ],
  "joins": [
    {
      "datasource": "data_procurement_report",
      "columns": [
        "level1_id",
        "level3_id",
        "level3",
        "state",
        "level4",
        "level5",
        "level5_id",
        "material_id_vendor",
        "vendor_id_name"
      ]
    }
  ],
  "syncMap": [
    {
      "source": "data_procurement_report",
      "targets": [
        "data_procurement_report"
      ]
    }
  ]
}

apply to element:

"syncSets": [{
    "syncSetId": "syncSet_procurement_report",
    "publishFilters": true,
    "applyFilters": true
  }]
3 Likes
4

Maybe one addition. If the table has a primary key (an unique identifier for each single row) I think it is enough to have this column referenced.

1 Like