question Re: uable to update field with dynamic value as it is Choice field. in ITSM forum

uable to update field with dynamic value as it is Choice field.

srinidhi — Tue, 26 Mar 2024 07:06:43 GMT

Hello Team,

How to update choice field dynamically, when i try to use below syntax it is creating duplicate record.

current.setValue(FieldName, displayName);

please suggest me here Thanks.

Re: uable to update field with dynamic value as it is Choice field.

Sohail Khilji — Tue, 26 Mar 2024 07:33:09 GMT

Hi @srinidhi ,

Can you explain your query bit clear ?

Re: uable to update field with dynamic value as it is Choice field.

srinidhi — Tue, 26 Mar 2024 07:42:50 GMT

Hello Sohail,

Through payload am storing all the values in different variables.

Am gliding to new table and creating the record with these values.

but for the choice field when i try to update, it's updating and making duplicate entry.

Re: uable to update field with dynamic value as it is Choice field.

Sohail Khilji — Tue, 26 Mar 2024 08:42:29 GMT

Make sure to set the appropriate value to your choice field. If it finds a diffrence to existing choices it will trend to create a new choice (may be duplication).

make sure to use techenical name of choice to set the value as example below for incident state.

g_form.getValue('state', '3'); // instead of inProgress use ''3''

Re: uable to update field with dynamic value as it is Choice field.

srinidhi — Tue, 26 Mar 2024 09:19:08 GMT

Yes Sohail, i got your point. but from the payload i will be getting the value as inProgress not 3 right.

Re: uable to update field with dynamic value as it is Choice field.

Deepak Shaerma — Tue, 26 Mar 2024 09:37:09 GMT

Hi @srinidhi

Please follow these steps to avoid creating duplicate entries when updating a choice field:

1. Unique Identification: Ensure that you’re using a unique identifier (like sys_id) to fetch the correct record you wish to update. This avoids creating a new record accidentally.

2. Correct Use of setValue for Choice Fields: For choice fields, make sure to use the internal value rather than the display value unless you’re using a method that specifically requires the label (display value).

3. Correctly Differentiate Between Insert and Update: Check if a record exists before deciding to insert a new one or update an existing one.

Considering you’re reading from a payload and creating or updating a record in a new table, here’s a refined approach:

var targetGR = new GlideRecord('target_table_name'); // Replace ‘target_table_name’ with the actual name of your target table // Assuming you have a unique identifier to check if it’s an update vs. insert. // For illustration, let’s use ‘unique_field’. targetGR.addQuery('unique_field', payload.unique_value); // ‘payload.unique_value’ should be replaced with how you’re accessing your payload’s unique identifier value targetGR.query(); if (targetGR.next()) { // This means a record exists, and we are updating it. } else { // No record found, so we’re creating a new one. targetGR.initialize(); targetGR.unique_field = payload.unique_value; // Set the unique field value for identification } // Set other fields including the choice field. Assuming ‘choiceFieldName’ is your choice field and ‘choiceFieldValue’ is the internal value you want to set. targetGR.choiceFieldName = payload.choiceFieldValue; // Ensure ‘payload.choiceFieldValue’ contains the internal value, not the display label // Save the changes targetGR.update(); // or targetGR.insert() if you’re creating a new record and haven’t used ‘next()’ on the GlideRecord.

Note: Please Mark this Helpful and Accepted Solution. If this Helps you to understand. This will help both the community and me..
- Keep Learning ‌‌
Thanks & Regards
Deepak Sharma

Re: uable to update field with dynamic value as it is Choice field.

srinidhi — Tue, 26 Mar 2024 10:22:18 GMT

Thanks for the detailed script.

My query here is for the below line of script, i need to give displayname only for choice field value, because for the payload i will be getting the displayname only.

targetGR.choiceFieldName = payload.choiceFieldValue; //

Re: uable to update field with dynamic value as it is Choice field.

Sohail Khilji — Tue, 26 Mar 2024 10:27:46 GMT

The do like this :

if(payload.choiceFieldValue == 'xxxx'){ //check values accordingly target.choiceFieldValue = 'backendvalue of choice field'; //set value based on your system techenical name }

Re: uable to update field with dynamic value as it is Choice field.

Sohail Khilji — Tue, 26 Mar 2024 10:29:13 GMT

why chat GPT ?

Re: uable to update field with dynamic value as it is Choice field.

swathisarang98 — Tue, 26 Mar 2024 11:09:15 GMT

Hi @srinidhi ,

You can not directly do this through set value, try to get values from Payload if that is not at all possible then as a workaround what you can do is store the state choice label inprogress or fetch that value in a variable and query sys_choice table and add table name in query and then set the state value .

example;

for testing i have a randon=m string field where i set value as In Progress and in before update business rule i gliderecord to sys_ choice table and got the value for label In progress and set the state value in incident,

BR:

(function executeRule(current, previous /*null when async*/ ) { var choiceLabel = current.u_string_1; //gs.info('label: ' + choiceLabel); var gchoice = new GlideRecord('sys_choice'); gchoice.addEncodedQuery('nameSTARTSWITHINCIDENT^element=state'); gchoice.addQuery('label', choiceLabel); // here i have added dummy value stored in a string to check but what you can do is get the pay load value store it in a variable and use that to query gchoice.query(); if (gchoice.next()) { //gs.info('value '+ gchoice.getValue('value')); current.setValue('state', gchoice.getValue('value')); } })(current, previous);

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang

Re: uable to update field with dynamic value as it is Choice field.

Sohail Khilji — Tue, 26 Mar 2024 11:21:11 GMT

Yes no matter what value you get from the payload even if its 3 or inprogress you can do a lookup/gliderecord on choice table get the appropriate value and use g_form.setValue(); to set the value. Let me know were your struck...

Re: uable to update field with dynamic value as it is Choice field.

swathisarang98 — Tue, 26 Mar 2024 17:57:11 GMT

@srinidhi ,Thanks for marking my answer as helpful. If it helped you in any way please accept the solution so that it will be beneficial to the future readers with the same query.

Thanks,

Swathi

Re: uable to update field with dynamic value as it is Choice field.

srinidhi — Tue, 26 Mar 2024 18:30:02 GMT

Hello @swathisarang98 and @Sohail Khilji ,

Below is my sample script and its output. In the screen shot we can see that two Software value came.

(function process(/*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) { try { var requestBody = request.body.data; var caller = requestBody.caller; var category = requestBody.category; var shortdescription = requestBody.shortdescription; // Insert record into UserTable var gr = new GlideRecord('incident'); gr.initialize(); gr.setValue('caller_id', caller); gr.setValue('category', category); gr.setValue('short_description', shortdescription); gr.insert(); response.setStatus(201); // 201 Created response.setBody({ message: "Records created successfully in incident table" }); } catch (ex) { response.setStatus(500); // 500 Internal Server Error response.setBody({ error: "An error occurred while processing the request" }); } })(request, response);

Re: uable to update field with dynamic value as it is Choice field.

swathisarang98 — Tue, 26 Mar 2024 18:37:28 GMT

@srinidhi can you put some log (gs.info) and add requestBody.category in it and share the screenshot or paste the log here?

Thanks

Swathi

Re: uable to update field with dynamic value as it is Choice field.

srinidhi — Wed, 27 Mar 2024 06:51:29 GMT

Hello @swathisarang98

Please find the gs.info log

Re: uable to update field with dynamic value as it is Choice field.

srinidhi — Wed, 27 Mar 2024 07:46:37 GMT

Hello @swathisarang98,

Thanks its working fine!!