Hi guys!
I have created a few search options for my gallery, all of which work fine. The newest added, "Project ID" can be selected, but is not filterong the search results in the gallery. It is returning error "Invalid schema, expected a one-column table".
The source for this combobox "Project ID" is a collection, the only thing (I can tell) that differs it from the other boxes. Does anyone know how I can fix this?
Code:
If(!IsBlank(rangeBox_1.Selected.DisplayName),
Filter('mib.mib_tbl_std_Savings', IsBlank(typeBox_1.SelectedItems.Val) || IsEmpty(typeBox_1.SelectedItems) || mib_fld_tbl_std_Saving_Type_varchar in typeBox_1.SelectedItems.Val, IsBlank(categoryBox_1.SelectedItems.Val) || IsEmpty(categoryBox_1.SelectedItems) || mib_fld_tbl_std_Saving_Category_varchar in categoryBox_1.SelectedItems.Val, IsBlank(regionBox_1.SelectedItems.Region_name) || IsEmpty(regionBox_1.SelectedItems) || mib_fld_tbl_std_Saving_Region_varchar in regionBox_1.SelectedItems.Region_name, IsBlank(countryBox_1.SelectedItems.Name) || IsEmpty(countryBox_1.SelectedItems) || mib_fld_tbl_std_Saving_Country_varchar in countryBox_1.SelectedItems.Name, mib_fld_tbl_std_Saving_StartDate_date >= rangeBox_1.Selected.StartDate && mib_fld_tbl_std_Saving_StartDate_date <= rangeBox_1.Selected.EndDate, IsBlank(ProjectIDBox_1.SelectedItems) || IsEmpty(ProjectIDBox_1.SelectedItems) || mib_fld_tbl_std_Saving_Type_varchar in ProjectIDBox_1.SelectedItems),
Filter('mib.mib_tbl_std_Savings', IsBlank(typeBox_1.SelectedItems.Val) || IsEmpty(typeBox_1.SelectedItems) || mib_fld_tbl_std_Saving_Type_varchar in typeBox_1.SelectedItems.Val, IsBlank(categoryBox_1.SelectedItems.Val) || IsEmpty(categoryBox_1.SelectedItems) || mib_fld_tbl_std_Saving_Category_varchar in categoryBox_1.SelectedItems.Val, IsBlank(regionBox_1.SelectedItems.Region_name) || IsEmpty(regionBox_1.SelectedItems) || mib_fld_tbl_std_Saving_Region_varchar in regionBox_1.SelectedItems.Region_name, IsBlank(countryBox_1.SelectedItems.Name) || IsEmpty(countryBox_1.SelectedItems) || mib_fld_tbl_std_Saving_Country_varchar in countryBox_1.SelectedItems.Name, IsBlank(ProjectIDBox_1.SelectedItems) || IsEmpty(ProjectIDBox_1.SelectedItems) || mib_fld_tbl_std_Saving_Type_varchar in ProjectIDBox_1.SelectedItems))
