List Collector choices based on Reference field value

ss123 · ‎08-31-2023

Hi!

In the Portal, we have this requirement in the catalog form where we need to filter the List Collector choices (sys_choice table) based on the value selected in Reference field (practice_group table)

Example:

When Reference field selected "Group 1", the List Collector choices should be [ G1, G2, G3 ]

When Reference field selected "Group 2", the List Collector choices should be [ B1, B2, B3 ]

Can I do this filtering via reference qualifier in the Collector field?

Thank you for your help.

S Goutham · ‎09-01-2023

@ss123 : As we discussed I have modified the script to cater to the requirement

var ListChoice = Class.create();
ListChoice.prototype = {
    initialize: function() {},
    getChoice: function(input_value) {
        try {
            var private_eui = gs.getProperty('private_equity_aol', '678ea9051b403340fb1fb9dcdd4bcbc6');
            var choices = [];
            var listvalue = new GlideRecord('sys_choice');
            if (input_value == private_eui)
                listvalue.addQuery('dependent_value', input_value);
            else
                listvalue.addEncodedQuery('element=u_transaction_type^name=u_deal_collection^dependent_value=NULL');
            listvalue.query();
            while (listvalue.next()) {
                choices.push(listvalue.sys_id.toString());
            }
            return choices.toString();
        } catch (e) {
            gs.log('Error in Script apple: ' + e);
        }
    },
    type: 'ListChoice'
};

I hope this solves your issue
Mark this as Helpful / Accept the Solution if this clears your issue

View solution in original post

ss123 · ‎09-01-2023

Thank you so much @S Goutham ! 🙂 Appreciate your time and assistance.