Good afternoon,
LPL - Can i have a list with a searchform where when i enter the value. that value be pass on as a filter in a relation?
meaning, i open a list and enter year 2022. that value 2022 be pass in a relation inside the list to only be filter the records for that one year using a Instance Selection?
something like this
EmployeeToHealthTotalPoints
one-to-many relation to ResourceHealthComponent
Field Mapping uses ByEmployeeHealthComponent
related.HROrganization = HROrganization
related.Employee = Employee
Instance Selection
where( related.ComponentStatus.Completed) and (related.WheelOfWellnessYear = "2022") -- 2022 is the value i enter in the searchform field passing to the relation
Thanks in advance