function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
DolgoldyDolgoldy 

Dependent picklist newly inserted value not showing in aura component

Hi all, there is program and sbu field which is dependent but newly added value in program not showing on ui. I adde in field dependency and record type
// apex class

 public static List<String> DigitalProgramPicklistValues(String sbu, String interactionType, String program){
        Set<String> pickListSet = new Set<String>(); 
        List<String> pickListList = new List<String>(); 
        String cmQuery;
        try {
            System.debug('sbu :: ' + sbu);
            System.debug('program :: ' + program);
            cmQuery = 'Select Id, Interaction_Type__c, Program__c, SBU__c,  FROM case where SBU__c =: sbu AND Program__c =: program';
            if(sbu == 'Digital Buisness'){
                for(Case ca : Database.query(cmQuery)){
                    pickListSet.add(ca.Program__c);
                }
                System.debug('Programs :: ' + pickListSet);
            }
            else if(program == ''){
                cmQuery += ' AND sbu__c =: sbu';
                System.debug('program QUERY :: ' + cmQuery);
                for(Case ca : Database.query(cmQuery)){
                    System.debug('program :: ' + pickListSet);
                    pickListSet.add(ca.program__c);
                }
                System.debug('program :: ' + pickListSet);
            }
           /* else if(subCategory == ''){
                cmQuery += ' AND __c =: program AND Category__c =: category';
                System.debug('Query :: ' + cmQuery);
                for(Category_Master__c cm : Database.query(cmQuery)){
                    pickListSet.add(cm.Sub_Category__c);
                }
                System.debug('subCategory :: ' + pickListSet);
            }

            for(String str: pickListSet){
                pickListList.add(str);
            }*/
            // return programSet;
        } catch (Exception e) {
            throw new AuraHandledException(e.getMessage());
        }
        return pickListList;
    }
 
// helper class

 // digital Buisness changes
     programPicklistValues1: function (cmp, event) {
        var action = cmp.get("c.DigitalProgramPicklistValues");
        var selectProgramValue = cmp.find('ProgramField').get('v.value');
        var selectInteractionValue = cmp.find('Interactiontypefield').get('v.value');
        console.log('Program :: ' + selectProgramValue);
        console.log('Interaction Type :: ' + selectInteractionValue);
        action.setParams({
            sbu: cmp.find('ProgramField').get('v.value'),
            interactionType: cmp.find('Interactiontypefield').get('v.value'),
            sbu: '',
            program: '',
            //subCategory: ''
        });
        // cmp.get("!v.Case_Record.SBU__c")
        // cmp.get("!v.Case_Record.Interaction_Type__c" )
        // var selectValue = cmp.find('SBUField').get('v.value');
        // console.log('type ' + cmp.find('Interactiontypefield').get('v.value'));

        action.setCallback(this, function(response) {
            var state = response.getState();
            if (state === "SUCCESS") {
                // Alert the user with the value returned 
                // from the server
                // alert("From server: " + response.getReturnValue());

                var programValues = [];
                sbuValues = response.getReturnValue();
                console.log('sbu Values:: '+  response.getReturnValue());
                var buList = [];
                buList.push({class: "optionClass",label: "--- Select one ---",value: ""});
                for(var i=0; i<sbuValues.length; i++){
                    console.log('Key::'+ sbuValues[i]);
                    buList.push({class: "optionClass",label:sbuValues[i],value:sbuValues[i]})
                }
                console.log(buList);
                cmp.set("v.sbuList", buList);

                // cmp.set("v.programList", response.getReturnValue());
                // You would typically fire a event here to trigger 
                // client-side notification that the server-side 
                // action is complete
            }
            else if (state === "INCOMPLETE") {
                // do something
            }
            else if (state === "ERROR") {
                var errors = response.getError();
                if (errors) {
                    if (errors[0] && errors[0].message) {
                        console.log("Error message: " + 
                                 errors[0].message);
                    }
                } else {
                    console.log("Unknown error");
                }
            }
        });
        $A.enqueueAction(action);
    },
    sbuChange: function(cmp, event){
        console.log('event::'+event)
        console.log('fg '+ event.getSource());
        var Sbu = event.getSource().get("v.value");
        cmp.set("v.Case_Record.sbu__c", sbu);
        console.log("sbu :: " + sbu);

        var action = cmp.get("c.DigitalProgramPicklistValues");
        action.setParams({
            sbu: cmp.find('ProgramField').get('v.value'),
            interactionType: cmp.find('Interactiontypefield').get('v.value'),
            sbu: cmp.get("v.Case_Record.sbu__c"),
            program: '',
            //subCategory: ''
        });

        action.setCallback(this, function(response) {
            var state = response.getState();
            if (state === "SUCCESS") {

                var ProgramValues = [];
                ProgramValues = response.getReturnValue();
                var buList2 = [];
                buList2.push({label: "--- Select one ---",value: ""});
                for(var i=0; i<programValues.length; i++){
                    console.log('Key::'+ programValues[i]);
                    buList2.push({label:programValues[i],value:programValues[i]});
                }
                console.log(buList2);
                cmp.set("v.programList", buList2);
            }
            else if (state === "INCOMPLETE") {
                // do something
            }
            else if (state === "ERROR") {
                var errors = response.getError();
                if (errors) {
                    if (errors[0] && errors[0].message) {
                        console.log("Error message: " + 
                                 errors[0].message);
                    }
                } else {
                    console.log("Unknown error");
                }
            }
        });
        $A.enqueueAction(action);

    },
    programChange: function(cmp, event){
        console.log('fg '+ event.getSource());
        var category = event.getSource().get("v.value");
        //cmp.set("v.categorySelected", category);
        console.log("program :: " + event.getSource().get("v.value"));
        cmp.set("v.Case_Record.program__c", event.getSource().get("v.value"));
        var program = cmp.get('v.Case_Record.sbu__c');
        var action = cmp.get("c.DigitalProgramPicklistValues");
        action.setParams({
            sbu: cmp.find('ProgramField').get('v.value'),
            interactionType: cmp.find('Interactiontypefield').get('v.value'),
            program: cmp.get("v.Case_Record.SBU__c"),
            category: cmp.get("v.Case_Record.Program__c"),
          //  subCategory: ''
        });
    },
 
js controller

   // to display program picklist for digital buisness
          var selectValue = cmp.find('ProgramField').get('v.value');
         console.log('type ' + cmp.find('ProgramField').get('v.value'));
        
  digitalProgram: function (cmp, event, helper) {
        // cmp.set("v.isNextBtnDisabled", true);
        helper.programPicklistValues1(cmp, event);
        helper.showSpinners(cmp);
        },