how to update request variable field values in change description servicenow

[sunil kumar11]

I have record producer for change table. When I submit the form the request details should update on change request - description field.

@shyam10

[kps sumanth · Accepted solution]

Hello @sunil kumar11 ,

You can write your record producer script as below,

var desc = '

\n Source Database Instance CI : ' + producer.corresponding variablename+'\n Source MSSQL DB  ORACLE Schema : '+ producer.corresponding variable name + like this add all the 6 variables and in the end add current.description = desc;

[sunil kumar11]

Hi @kps sumanth 

I need to  get only 6 fields to shown in the description as you can see the screenshot which i have shared

[The Machine · Accepted solution]

Yeah you could do something like.

current.description = 'Source MSSQL DB: ' + producer.mssql_variable + '\n';
current.description += 'Hostname: ' + producer.hostname_variable+ '\n';
current.description += 'Source Environment: ' + producer.source_env_variable+ '\n';

And so on.

[sunil kumar11]

Hi @The Machine @kps sumanth 

Great its working 🙂

only 1 doubt here . SYS ID is getting instead of CI name

Source Database Instance CI: c57ee6e3db8a4094a7c09635db961951

[The Machine]

Add .getDisplayValue() to the end of producer.variable_name for any reference fields.

producer.ci_name.getDisplayValue()

[kps sumanth · Accepted solution]

Hello @sunil kumar11 ,

You can write your record producer script as below,

var desc = '

\n Source Database Instance CI : ' + producer.corresponding variablename+'\n Source MSSQL DB  ORACLE Schema : '+ producer.corresponding variable name + like this add all the 6 variables and in the end add current.description = desc;