question Get all variables on a task form via script in Developer forum

Get all variables on a task form via script

nickmayo — Fri, 22 Jul 2016 20:05:21 GMT

Hey all,

I'm trying to do something that may or may not be simple.

Basically, we have mandatory fields on our Catalog Tasks for users to populate. Where we're at however, users will pass tasks between each other or try to assign them before populating the mandatory tasks. The problem we run into is once you go to a task, you can assign and save the record without filling out those mandatory tasks. I'm trying to avoid making a UI policy for every mandatory task we have that says "be non mandatory unless the task state changes to Closed Complete".

So my question is: Is there a way to grab all mandatory variables off a Catalog Task form VIA Client script? Or at least grab all variables regardless of mandatory?

Or even (hopefully?) simpler, is there a way to modify this code to grab all the variables in the map, then check if they are mandatory? If so, set them non mandatory? I've been banging my head against this for awhile and a scalable solution would be perfect so we don't have to create a new UI policy everytime we need a new variable.

function onLoad(){
     try{
           //Get the 'Variables' section
           var ve = $('variable_map').up('table');
           //Disable all elements within with a class of 'cat_item_option'
           ve.select('.cat_item_option', '.slushselectmtm', '.questionsetreference').each(function(elmt){
         //CURRENTLY this will make ALL variables read only. I would like something like the following
         //if(elmt.mandatory = true){
         //         g_form.setMandatory(false);
         //}
                 elmt.disabled = true;
           });
   
     catch(e){}
}

Re: Get all variables on a task form via script

Abhinay Erra — Fri, 22 Jul 2016 20:35:07 GMT

You can write this in display business rule and then set them mandatory to false in your onload client script

var mandatory_fields=[];

var set = new GlideappVariablePoolQuestionSet();

set.setRequestID('put your request item sys_id');

set.load();

var vs = set.getFlatQuestions();

for (var i = 0; i < vs.size(); i++) {

if(vs.get(i).mandatory==true){

mandatory_feilds.push(vs.get(i).getName());

}

g_scratchpad.mandataoryArray=mandatory_fields;

In your client script use this

for (i=0; i<g_scratchpad.mandatoryArray.length;i++){

g_form.setMandataory(g_scratchpad.mandatoryArray[i],false);

}

Re: Get all variables on a task form via script

nickmayo — Mon, 25 Jul 2016 16:57:42 GMT

Abhinay,

This is definitely helpful but it's not grabbing the actual variables for me. It's missing a couple for me (2 drop downs and a string)

Is there any limitations with your script? For example, does it ignore variable sets?

Re: Get all variables on a task form via script

Abhinay Erra — Mon, 25 Jul 2016 17:18:42 GMT

Nope, it should have grabbed all the variables which have mandatory set to true

Re: Get all variables on a task form via script

nickmayo — Mon, 25 Jul 2016 18:07:08 GMT

Ah, I have found the issue.

This only works for variables that are checked off as mandatory because its checking at display. The ones I need to change are being set to mandatory by a UI policy. Variables that are not mandatory by default will not work with this solution.

I'll see if I can re-work this to check after the UI policy.

Thanks for the help!

Re: Get all variables on a task form via script

Abhinay Erra — Mon, 25 Jul 2016 18:15:08 GMT

Ahh.. I do not think this will work with a display business rule. Since

display business rule is triggerred before a record is actually displayed.

I will recommend to use a glideajax in a client script and put the server

side script in a script include.

On Monday, July 25, 2016, nickmayo <community-no-reply@servicenow.com>

Re: Get all variables on a task form via script

Abhinay Erra — Mon, 25 Jul 2016 18:37:43 GMT

Try it and let me know if you have any questions.

Re: Get all variables on a task form via script

nickmayo — Mon, 25 Jul 2016 19:02:44 GMT

So I've got it to return the variables, but it's still only pulling ones thats are actually marked as mandatory vs ones changed to mandatory via UI policy.

I put it in an onChange script instead, but even if I run it after the page loads it doesn't pull the ones affected by the UI policy. Any suggestions? The code is running fine, but I think I just need to see if there is a way to check if a UI policy is affecting the variables. Below is my code so far:

Client Script:

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

   if (isLoading || newValue == 3) {

   var ga = new GlideAjax('mandatoryVariables');

   ga.addParam('sysparm_name','MandatoryVariables');

   ga.addParam('sysparm_value', g_form.getValue('request_item')); //send RITM number

   ga.getXML(ajaxResponse);

   }

}



function ajaxResponse(serverResponse) {

   var result = serverResponse.responseXML.getElementsByTagName("result");

   var message = result[0].getAttribute("message");

   if(message){

   alert(message);}


   var output = "";

   var variables = serverResponse.responseXML.getElementsByTagName("variable");

   for (i=0; i < variables.length ; i++){

   //g_form.setMandatory(variables[i],false);

   var name = variables[i].getAttribute("name");

   output += name + "\n" ;

   }

   alert(output);

}

Script include:

var mandatoryVariables = Class.create();

mandatoryVariables.prototype = Object.extendsObject(AbstractAjaxProcessor, {

   MandatoryVariables: function(){

   var result = this.newItem("result");

   result.setAttribute("message", "returning mandatory variables");

   var set = new GlideappVariablePoolQuestionSet();

   set.setRequestID(this.getParameter('sysparm_value'));

   set.load();

   var vs = set.getFlatQuestions();

   for (var i = 0; i < vs.size(); i++) {

   if(vs.get(i).mandatory==true){

   this._addVariable(vs.get(i).getName());

   }

   }

   },


   _addVariable : function(name) {

   var vars = this.newItem("variable");

   vars.setAttribute("name", name);

   },



   type: 'mandatoryVariables'

});

Re: Get all variables on a task form via script

nickmayo — Mon, 25 Jul 2016 20:00:02 GMT

Bump - does anyone have any ideas here?

We need this functionality. I've found other threads where folks are adding UI actions and making all variables non mandatory, but I need only a couple marked as non mandatory. UI policies are not an option here.

Re: Get all variables on a task form via script

Abhinay Erra — Mon, 25 Jul 2016 20:34:01 GMT

Do you want to make everything as non-mandatory or only a specific variables?

Re: Get all variables on a task form via script

nickmayo — Mon, 25 Jul 2016 20:45:08 GMT

Only specific variables i.e any variables that are set to mandatory by a UI policy.

Basically I need the functionality from the pop up that prevents you from saving a record when you have mandatory variables (the following mandatory variables have not been filled in pop up) but in my script so I can read variables that are set to mandatory from a policy and not the dictionary.

I need this because we add variables frequently and making UI policies for each variable is going to take far too long.

Sent from my Verizon, Samsung Galaxy smartphone

Re: Get all variables on a task form via script

Abhinay Erra — Mon, 25 Jul 2016 21:05:36 GMT

Well you can make all the fields non-mandatory by using this in your client script. Let me know hoe it goes

Client script:

var allVariables = document.getElementById('variable_map').getElementsByTagName('item');

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

   var item = allVariables[i];

   g_form.setMandatory('variables.' + item.getAttribute('qname').toString(),false);

   }

Re: Get all variables on a task form via script

nickmayo — Mon, 25 Jul 2016 21:09:44 GMT

Yes, I found that solution as well but that won't work. Take the following scenarios.

On a task I have 5 variables. 3 are mandatory by UI policy, 2 are not. If I use that solution, it'll work by making all of them not mandatory. But as soon as my condition reverses, it will make all 5 mandatory, which makes two of the variables that do not need to be mandatory, mandatory. Does that make sense?

Sent from my Verizon, Samsung Galaxy smartphone

Re: Get all variables on a task form via script

Abhinay Erra — Mon, 25 Jul 2016 21:13:42 GMT

I have not tried, but why would it make other two as mandatory? We are not using them in UI policy right?

Re: Get all variables on a task form via script

nickmayo — Tue, 26 Jul 2016 14:03:24 GMT

This

var allVariables = document.getElementById('variable_map').getElementsByTagName('item');

grabs all variables regardless of state.

So this will work when setting them non-mandatory BUT when you go to set the variables BACK to mandatory, its going to set all variables to mandatory.

Re: Get all variables on a task form via script

Abhinay Erra — Tue, 26 Jul 2016 14:08:13 GMT

I understand that part. How are you setting it to mandatory? I believe it is by using UI policies right? Then it will only set mandatory that 2 or 3 fields which you have in that UI policy.