How to clear previous reference field value and then select new one on UI Page

[Vaibhav39]

Hello.
I have three reference fields on UI page: Company, Code & Type.
On click of UI action I'm able to populate those fields from form to UI page.
When I change company then the other two fields (values from fields) should get cleared. I'm able to achieve this using gel('<field>').value =''; and gel('sys_display.<field>').value='';

The issue is, when I select value from other two reference fields it is not showing. May be it gets cleared again.
I would really appreciate if I get any kind of help here.
TIA.

[Ankur Bawiskar]

Hi,

But since your Urgency and Style are dependent on Company it will lead to data issue if you allow them to select Urgency without Selecting Company

Regards
Ankur

[Vaibhav39]

Yes, I've done the same thing.
Company field is mandatory. If company is empty then below two fields will be read only.

Form values in the fields are coming as is when I click on UI action.

Issue is the code I wrote is clearing the selected value again & agian.

Code:

if (companyId == '' || companyId == 'null') {
        gel('u_urgency_code').value = "";
        gel('sys_display.u_urgency_code').value = "";
        gel('sys_display.u_urgency_code').readOnly = true;
        urgencyLookUp.style.display = "none";
        gel('u_pcd_style').value = "";
        gel('sys_display.u_pcd_style').value = "";
        gel('sys_display.u_pcd_style').readOnly = true;
        styleLookUp.style.display = "none";
    } else {
        gel('u_urgency_code').value = "";
        gel('sys_display.u_urgency_code').value = "";
        gel('sys_display.u_urgency_code').readOnly = false;
        urgencyLookUp.style.display = "";
        gel('u_pcd_style').value = "";
        gel('sys_display.u_pcd_style').value = "";
        gel('sys_display.u_pcd_style').readOnly = false;
        styleLookUp.style.display = "";
 }

Above if loop is working fine but else loop is clearing both the field values every time.

Please help me to resolve this.

[Ankur Bawiskar]

Hi,

Can you share your latest script for HTML, Client Script

Regards
Ankur

[Vaibhav39]

HTML:

<g:ui_reference name="company" id="company" completer="AJAXTableCompleter" table="core_company" displayValue="${jvar_companyDisplayName}" value="${jvar_companyName}" query="active=true" onchange="showUrgencyAndStyle()"/>

<g:ui_reference name="u_urgency_code" id="u_urgency_code" completer="AJAXTableCompleter" table="u_fsmm_urgency_code" displayValue="${jvar_urgencyDisplayName}" value="${jvar_urgencyCode}" query="u_active=true^u_company=${jvar_companyName}"/>

<g:ui_reference name="u_pcd_style" id="u_pcd_style" completer="AJAXTableCompleter" table="u_pcd" displayValue="${jvar_styleDisplayName}" value="${jvar_styleName}" query="u_active=true^u_company=${jvar_companyName}"/>

<g:dialog_buttons_ok_cancel ok="return submitValues();" cancel="return onCancel();" />

Client script:

function showUrgencyAndStyle() {
    var companyId = gel('company').value;
    var urgencyLookUp = gel('lookup.u_urgency_code');
    var styleLookUp = gel('lookup.u_pcd_style');
    var urgencyArray = [];
    var styleArray = [];

    if (companyId == '' || companyId == 'null') {
        gel('u_urgency_code').value = "";
        gel('sys_display.u_urgency_code').value = "";
        gel('sys_display.u_urgency_code').readOnly = true;
        urgencyLookUp.style.display = "none";
        gel('u_pcd_style').value = "";
        gel('sys_display.u_pcd_style').value = "";
        gel('sys_display.u_pcd_style').readOnly = true;
        styleLookUp.style.display = "none";
    } else {
        gel('u_urgency_code').value = "";
        gel('sys_display.u_urgency_code').value = "";
        gel('sys_display.u_urgency_code').readOnly = false;
        urgencyLookUp.style.display = "";
        gel('u_pcd_style').value = "";
        gel('sys_display.u_pcd_style').value = "";
        gel('sys_display.u_pcd_style').readOnly = false;
        styleLookUp.style.display = "";
    }
    
    //Filter for Urgency code based on company
    var grUrgency = new GlideRecord("u_fsmm_urgency_code");
    grUrgency.addQuery('u_active', true);
    grUrgency.addQuery('u_company', companyId);
    grUrgency.addQuery("u_urgency_code", "!=", "");
    grUrgency.query();
    while (grUrgency.next()) {
        urgencyArray.push(grUrgency.sys_id.toString());
    }
    urgencyLookUp.setAttribute('onclick', "mousePositionSave(event); reflistOpen('u_urgency_code', 'not', 'u_fsmm_urgency_code', '', 'false', 'QUERY:u_active=true', 'sys_idIN" + urgencyArray + "', '')");

    //Filter for Style based on company
    var grStyle = new GlideRecord("u_pcd");
    grStyle.addQuery('u_active', true);
    grStyle.addQuery('u_company', companyId);
    grStyle.addQuery("u_style", "!=", "");
    grStyle.query();
    while (grStyle.next()) {
        styleArray.push(grStyle.sys_id.toString());
    }
    styleLookUp.setAttribute('onclick', "mousePositionSave(event); reflistOpen( 'u_pcd_style', 'not', 'u_pcd', '', 'false', 'QUERY:u_active=true', 'sys_idIN" + styleArray + "', '')");
}

[Ankur Bawiskar]

Hi,

You don't require that else.

1) if the company is cleared then clear Urgency and Style

2) if the company is changed the allow the script to set the filter for Urgency and Style

Updated Client Script:

function showUrgencyAndStyle() {
	var companyId = gel('company').value;
	var urgencyLookUp = gel('lookup.u_urgency_code');
	var styleLookUp = gel('lookup.u_pcd_style');
	var urgencyArray = [];
	var styleArray = [];

	if (companyId == '' || companyId == 'null') {
		gel('u_urgency_code').value = "";
		gel('sys_display.u_urgency_code').value = "";
		gel('sys_display.u_urgency_code').readOnly = true;
		urgencyLookUp.style.display = "none";
		gel('u_pcd_style').value = "";
		gel('sys_display.u_pcd_style').value = "";
		gel('sys_display.u_pcd_style').readOnly = true;
		styleLookUp.style.display = "none";
		return;
	} 
	else{
		//Filter for Urgency code based on company
		var grUrgency = new GlideRecord("u_fsmm_urgency_code");
		grUrgency.addQuery('u_active', true);
		grUrgency.addQuery('u_company', companyId);
		grUrgency.addQuery("u_urgency_code", "!=", "");
		grUrgency.query();
		while (grUrgency.next()) {
			urgencyArray.push(grUrgency.sys_id.toString());
		}
		urgencyLookUp.setAttribute('onclick', "mousePositionSave(event); reflistOpen('u_urgency_code', 'not', 'u_fsmm_urgency_code', '', 'false', 'QUERY:u_active=true', 'sys_idIN" + urgencyArray + "', '')");

		//Filter for Style based on company
		var grStyle = new GlideRecord("u_pcd");
		grStyle.addQuery('u_active', true);
		grStyle.addQuery('u_company', companyId);
		grStyle.addQuery("u_style", "!=", "");
		grStyle.query();
		while (grStyle.next()) {
			styleArray.push(grStyle.sys_id.toString());
		}
		styleLookUp.setAttribute('onclick', "mousePositionSave(event); reflistOpen( 'u_pcd_style', 'not', 'u_pcd', '', 'false', 'QUERY:u_active=true', 'sys_idIN" + styleArray + "', '')");
	}
}

Regards
Ankur