Catalog Item Variables Deletion

[Alpcan]

Hello eveyone, I have an issue about deletion of catalog item variables with script. My categories, catalog items and catalog item variables have been created and automated using script. But there is a problem about deletion of catalog item variables with script. I can't delete any catalog item variables. I have specified the script section I used below.

var gr = new GlideRecord("item_option_new");
	gr.addQuery('sys_scope',scope);
	gr.query();
	if(gr.next()){
		gr.deleteRecord(true);
        }

[Mohith Devatte]

Hello @Alpcan ,

You need to specify for which catalog item you are deleting the variables for by adding one more addQuery like below 

var gr = new GlideRecord("item_option_new");
	gr.addQuery('sys_scope',scope); // your scope name
gr.addQuery('cat_item','your_catalog_item_sys_id');

	gr.query();
	while(gr.next()){ // use while to delete multiple variables
		gr.deleteRecord(); //no need to pass true as param for deleteRecord method
        }

Hope this helps 

Mark my answer correct if this helps you 

Thanks

[Alpcan]

Hello @Mohith Devatte,

Thanks for your quick reply. I tried what you said, but I still could not delete it. When I check the logs, I can see the variable names of the catalog item.

var gr = new GlideRecord("item_option_new");
	gr.addQuery('sys_scope',scope);
	gr.addQuery('cat_item',cat_sys_id);
	gr.query();
	while(gr.next()){
		gs.info(gr.name);
		gr.deleteRecord();
	}

[Mohith Devatte]

@Alpcan are you trying this in background scirpt ? 

please try running it in BG as it immediately shows in the output if it has scope issues to delete the record.

I am assuming its a cross scope issue where you don't have access to delete the records 

Please try running the script in BG and let me know the output 

Thanks

[Alpcan]

@Mohith Devatte there is the output. How can I solve this?