How to set filter for glide_list type modal filter.

chandan15
Tera Contributor

Hi,

I am using Declarative Action for SIR-WS new button client script and using modal on onClick fucntion to popup few field. There is one Glide_List type field, where I wanted to add filter, and the default value displayvalue not sys_id:-

function onClick() {

    var fields = [{
        type: 'glide_list', //'reference',
        name: 'u_member_firm_region_affected',
        label: getMessage('What is your MF?'),
        mandatory: true,
        reference: 'core_company',
        sysparm_query: 'sys_idIN' + (g_form.getValue('u_member_firm_region_affected') || ''),
        referringTable: 'sn_si_incident',
        referringRecordId: g_form.getUniqueValue(),
        value: g_form.getValue('u_member_firm_region_affected'),
        displayValue: g_form.getDisplayValue('u_member_firm_region_affected')
    }];

    g_modal.showFields({
        title: "Enter your reason",
        fields: fields,
        size: 'lg'
    }).then(function(fieldValues) {

        g_form.setValue('work_notes', "Reason for the containment: " + fieldValues.updatedFields[0].value);
        g_form.save();
    });
}

 

The filter I want:

'sys_idIN' + (g_form.getValue('u_member_firm_region_affected') || ''),
And u_member_firm_region_affected i sthe glideList type field of current record.
Currently it is showing sys_id instead of displayValue();
 

modal 2026-03-20 173415.jpg

 

 

Please, kindly help me on this.
 
 
Thanks,
Chandan

 

0 REPLIES 0