Skip to main content
kavyam0002
kavyam0002
March 31, 2022
Solved

Choice values and choice label

  • March 31, 2022
  • 4 replies
  • 0 views

Hi,

i have two dropdown field, when i select one some values related to that dropdown will be selected in next dropdown.. but after selecting values in both the dropdown when i try to change the value in first dropdown it throwing the error.. actually it has to erase the value in second dropdown and show the values to select 

below i have attached the code and the UI

this is the UI for ex: when i select stand-by lc and related detail i have to select after selecting the detail if i try to change the collateral type then it is giving error 

when i try to change the collateral type then detail data need to erase how can i achieve this  

 a!dropdownField(
                /*label:"Collateral Type"*/
                placeholderLabel: cons!CR_APP_TXT_PLACEHOLDER_VALUE,
                choiceLabels: touniformstring(
                  rule!APN_distinct(
                    index(
                      ri!crREFCollateral_cdt,
                      "collateralDescription_txt",
                      {}
                    )
                  )
                ),
                choiceValues: touniformstring(
                  rule!APN_distinct(
                    index(
                      ri!crREFCollateral_cdt,
                      "collateralCode_int",
                      {}
                    )
                  )
                ),
                value: tostring(
                  index(
                    fv!item,
                    "collateralCode_int",
                    {}
                  )
                )
              ),
              a!dropdownField(
                /*label:"Detail"*/
                placeholderLabel: cons!CR_APP_TXT_PLACEHOLDER_VALUE,
                choiceLabels: index(
                  ri!crREFCollateral_cdt,
                  wherecontains(
                    fv!item.collateralCode_int,
                    ri!crREFCollateral_cdt.collateralCode_int
                  ),
                  {}
                ).collateralTypeDescription_txt,
                choiceValues: touniformstring(
                  index(
                    ri!crREFCollateral_cdt,
                    wherecontains(
                      tostring(
                        fv!item.collateralCode_int
                      ),
                      touniformstring(
                        ri!crREFCollateral_cdt.collateralCode_int
                      )
                    ),
                    {}
                  ).collateralTypeCode_int
                ),
                value: tostring(
                  fv!item.collateralTypeCode_int
                )
              )

    Best answer by gopalk2865

    HI kavyam0002, To make this working, you would need to make sure you are making second dropdown value null whenever first dropdown's value changes. So in first doropdown's saveInto parameter , just make that value null.it should fix your problem then.

    4 replies

    gopalk2865
    gopalk2865Answer
    Participating Frequently
    March 31, 2022

    HI kavyam0002, To make this working, you would need to make sure you are making second dropdown value null whenever first dropdown's value changes. So in first doropdown's saveInto parameter , just make that value null.it should fix your problem then.

      kavyam0002
      kavyam0002Author
      April 4, 2022

      Hi [mention:8b930cc189ea4ddf8fcb9c275d619049:e9ed411860ed4f2ba0265705b8793d05]  i have included mentioned code in saveInto instead of value parameter 

       fv!item.collateralCode_int,
                  a!save(
                    fv!item.collateralTypeCode_int,
                    null
                  ),

      gopalk2865
      gopalk2865
      Participating Frequently
      April 4, 2022

      Great!

      mikes0011
      mikes0011
      Brainy
      March 31, 2022

      You'd need to show us the saveInto parameters of both dropdowns, particularly the first one as per what Gopalk already said, the first one will need to manually save a blank value into the value being used by the second one, to prevent its value from becoming an invalid selection when the value in the first one is changed.

      Also: I would strongly recommend against using "distinct" funcitons separately on the "choiceLabels" and "choiceValues" arrays like you're currently doing in the top dropdown - because you will very quickly find yourself in a situation where the dropdown breaks when one of those arrays contains a duplicate and the other one doesn't, thus causing both lists to be different lengths, which will break the dropdown field.

      I would replace these with simply this:

      choiceLabels: property( ri!crREFCollateral_cdt, "collateralDescription_txt", {} ),
choiceValues: property( ri!crREFCollateral_cdt, "collateralCode_int", {} ),

      If you're worried that ri!crREFCollateral_cdt will contain duplicate entries, you should do the de-duplication on the CDT array as a whole, either at query time or right afterwards (like in a subsequent local variable).  I also removed the toUniformString calls as they are almost never necessary in this context.

      The Expression Guru
      Terms & ConditionsAccessibility statement