Dynamic Dropdown Menu

[cc11]

I have three fields as shows in the screenshot below,

1 User selects Category = 'Software'

2 On clicking Type dropdown, we want to query a Table called 'Inventory' (where we have Category, Type & Subtype columns data) and pull matching Type values from there.

But here is another thing - while displaying Type values, we need to transform them by appending Type & Subtype together with a dot(.) and making them lowercase.

So the Type dropdown should show the values in this format ->   type.subtype

Is this possible?

Thank you,

Yogesh

[cc11]

Thanks Shishir,

I have changed it to type 'Choice'.

Just one more question on var order = this.getParameter('sysparm_order');

Should the variable category be from my backend form or the UI form where the dropdown is being displayed?

And should this be in the format of syspart_<variable> ?

Thank you again,

Yogesh

[cc11]

At the moment, Category is a reference field and Type is a Choice field.

[Shishir Srivast]

sysparm_order is just a variable you can have any name. whatever variable you are using in client scripting you have use the same variable in getParameter() in script include.

if Category is a reference field then it will pass the sys_id, you have to do GlideQuery using the sys_id,   hope inventory_cat would be a reference field too in your inventory table.

[cc11]

Thanks Shishir,

Below are my scripts -  

On the UI, Category is of type Reference, Type is Choice.

On backend(Inventory Table) - Inventory_Cat is of type Reference, Inventory_Type is a String.

-----------Client Script--------------

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

if (isLoading || newValue === '') {

return;

}

g_form.clearOptions('type'); //change the field name with dependent field name

var listDetails = new GlideAjax("DisplayTypeList");

listDetails.addParam("sysparm_name", "getListDetails");

listDetails.addParam("sysparm_category", newValue);

listDetails.getXML(ajaxResponse);

function ajaxResponse(serverResponse) {

var answer = serverResponse.responseXML.documentElement.getAttribute("answer");

var myObj = JSON.parse(answer);

if(myObj.length > 0)

{

for(var i = 0; i<myObj.length; i++)

{

g_form.addOption('type', myObj[i].toLowerCase(), myObj[i].toLowerCase()); //Replace the field name where you have to assign the value

}

}

}

}

-----------Script Include--------------

var DisplayTypeList = Class.create();

DisplayTypeList.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {

getListDetails : function() {

var list = [];

var gr = new GlideRecord('x_12345_app_inventory'); //Replace with your table name

var cat = this.getParameter('sysparm_category');

//gr.addQuery('element', order); //Add your queries here

gr.addQuery('inventory_cat',cat);

gr.query();

while(gr.next())

{

var item_val = gr.getValue('inventory_type'); // Replace the field names from where you have to fetch the value

list.push(item_val);

}

return JSON.stringify(list);

},

      type: 'DisplayTypeList'

});

[cc11]

In my script, I am trying to return only the Inventory_Type (not the concatenation of Inventory_Cat.Inventory_Subtype) , just to keep it simple for testing.