Show variables of Selected Catalog Item on Portal while raising a new request for Modification.

Naveen87 · ‎02-24-2023

Hi Developers,

I'm trying to build a new Catalog Item for Minor changes required on existing Catalog Item on the system.

I just have rough design in my mind & I was wondering,

How can I create a variable in New Item, Which will show all variable of the selected Catalog Item that user wants to modify.

Ex:- Below I have selected "Naveen Learning" Catalog Item.

Now I want to create a new variable below this ("Select Catalog Item") which will show all available variable under this Item. So user can select for modification.

I tried to create a variable referencing to item_option_new table but this show all the variables available in the system. I need to show only which are related to above selected Catalog Item.

Please suggest.

Thank you.

Ankur Bawiskar · ‎03-01-2023

@Naveen87

variables can be directly linked to catalog item or they can be part of some variable set

so use this; you need to use script include for this

javascript&colon;'cat_item='+ current.variables.choose_variable_from_the_catalog + '^ORsys_idIN' + fetchVariables(current.variables.choose_variable_from_the_catalog);

function fetchVariables(itemSysId){

	var arr = [];
	var gr = new GlideRecord("io_set_item");
	gr.addQuery("sc_cat_item", itemSysId);
	gr.query();
	while(gr.next()) {
		var rec = new GlideRecord('item_option_new');
		rec.addQuery('variable_set', gr.variable_set);
		rec.query();
		while(rec.next()){
			arr.push(rec.getUniqueValue());
		}
	}
	return arr.toString();

}

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Ankur Bawiskar · ‎03-01-2023

@Naveen87

that's correct.

It's admin job to update/associate variables to catalog item and not end user's task

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader