Hi
I need help with a filter/sort on a Gallery (Gal_AllCandidatesView).
I have a DropDown Dd_ChooseResponsible, where I need to Filter on the value Liable (it's a text column in Salary_MasterData and contains names), so if I chosse the name Peter in Dd_ChooseResponsible, then Gal_AllCandidatesView should only show Peter's candidates.
But I then also have a ComboBox CBox_SearchCandidate, where I can filter on the candidates Name or Mail (also from Salary_MasterData): I need to have Dd_ChooseResponsible working independent of CBox_SearchCandidate and vice versa.
So when I find Peter in Dd_ChooseResponsible, it shows Peter's candidates, when I then reset the filters and will filter for all users with the names starting with B in CBox_SearchCandidate it should find all users with B in name or mail.
varSortValue and varSortDirection are from OnStart.
Set(varSortValue, "VIP"),
Set(varSortDirection, "Descending")
SortByColumns(
Filter(
Salary_MasterData,
Concluded = false,
(IsBlank(Dd_ChooseResponsible.Selected.Result) || Liable = Dd_ChooseResponsible.Selected.Result)
||
(IsBlank(CBox_SearchCandidate.SelectedItems) || CandidateName = CBox_SearchCandidate.Selected.CandidateName || CandidateMail = CBox_SearchCandidate.Selected.CandidateMail)
),
varSortValue, //variabel sat i OnStart
varSortDirection, //variabel sat i OnStart
"VIP", SortOrder.Descending,
"CandidateStartDate", SortOrder.Ascending,
"CandidateName", SortOrder.Ascending,
"Styrelse", SortOrder.Ascending,
"Liable", SortOrder.Ascending,
"CandidateMail", SortOrder.Ascending
)
