Need to understand the Cascading of Drop down concept when data is from DB tables. with update functionality

Question

Hi,Could someone help me understand the concept and solve my below problem?
I have a Two tables
1. VehicleTypesFieldId   category1    Cars2    Buses3   Trains
2nd table SubVehicleTypes
SubID Id SubCategory1         1     Sedan2         1     Suv3         2     Luxury4         2     Semi luxury5         3     Ac Trains6         3     Non Ac Trains
Requirements:1. Drop Down 1 will have data from Table 12. Drop Down 2 will have data from Table 2

I want to display the selected field in 2nd dropdown with the list like
Actually i want this

amans0009 · Answer

a!localVariables(
  local!vehicle:{
    a!map(id:1,type:"car"),
    a!map(id:2,type:"Bus"),
  },
  local!subvehicle:{
    a!map(id:1,vehId:1,type:"ac-car"),
    a!map(id:2,vehId:1,type:"non-ac-car"),
    a!map(id:3,vehId:2,type:"ac-Bus"),
    a!map(id:4,vehId:2,type:"non-ac-Bus"),
  },
  local!selectedVehicleType,
  local!selectedSubvehicleType,
  {
  a!dropdownField(
    label: "Dropdown",
    labelPosition: "ABOVE",
    placeholder: "--- Select a Value ---",
    choiceLabels: local!vehicle.type,
    choiceValues: local!vehicle.id,
    value: local!selectedVehicleType,
    saveInto: {local!selectedVehicleType},
    searchDisplay: "AUTO",
    validations: {}
  ),
    a!multipleDropdownField(
      label: "Multiple Dropdown",
      labelPosition: "ABOVE",
      choiceLabels:index(local!subvehicle.type,wherecontains(tointeger(local!selectedVehicleType),tointeger(local!subvehicle.vehId)),{}),
      choiceValues:index(local!subvehicle.id,wherecontains(tointeger(local!selectedVehicleType),tointeger(local!subvehicle.vehId)),{}),
      saveInto: {local!selectedSubvehicleType},
      value: local!selectedSubvehicleType,
      searchDisplay: "AUTO",
      validations: {}
    )
}
)

Sign up

Login with SSO

Login to the community

Login with SSO