Need Dependent Year multidropdown filters

Hi ,

I want to diplay two filters one is Date and another one is on Year.

Date filter should be display of value of Year filter only.

By Year filter should display current year and Date should be current year date.

I have both in multidropdown separately without dependent to each other.

My requirement is to make dependent.

 local!year: year(
    today()
  ),
  
a!multipleDropdownField(
                  label: "Date",
                  choiceLabels:todate(
                    reject(
                      fn!isnull,
                      union(
                        local!dateList,
                        local!dateList
                      )
                    )
                  ),
                  choiceValues: reject(
                    fn!isnull,
                    union(
                      local!dateList,
                      local!dateList
                    )
                  ),
                  value: local!date,
                  saveInto: {
                    local!date,
                    a!save(
                      local!pagingInfo.startIndex,
                      1
                    )
                   
                  },
                  placeholderLabel: "All"
                ),
				 a!multipleDropdownField(
                  label: "Year",
                  choiceLabels: reject(
                    fn!isnull,
                    union(
                      local!yearList,
                      local!yearList
                    )
                  ),
                  choiceValues: reject(
                    fn!isnull,
                    union(
                      local!yearList,
                      local!yearList
                    )
                  ),
                  value: local!year,
                  saveInto: {
                    local!year,
                    a!save(
                      local!pagingInfo.startIndex,
                      1
                    )
                  placeholderLabel: "All"
                )

  Discussion posts and replies are publicly visible

Parents Reply
  • Yes you are correct i need an cascading operation . But here i am getting list of year and date from dataset. Table grid and Multidropdown filter criteria is getting load first time with default current year. I mean Year-20202 n Date-All year dates are coming. I need to make changes that always Date should be filter on basis of Year filter only. If year is 2020 then 2020-Date should be come in Date dropdown.

Children
No Data