question Re: Using fix script same table we need to copy from one field to other field in Developer forum

Using fix script same table we need to copy from one field to other field

mani55 — Wed, 26 Nov 2025 12:48:16 GMT

Using fix script same table we need to copy from one field to other field i tried with below code but it's not working let me know my mistake

Re: Using fix script same table we need to copy from one field to other field

Sarthak Kashyap — Wed, 26 Nov 2025 12:59:49 GMT

Hi @mani55 ,

Maybe try with below code

Please mark my answer correct and helpful if this works for you

Thanks and Regards,

Sarthak

Re: Using fix script same table we need to copy from one field to other field

soumyadeep10 — Wed, 26 Nov 2025 13:16:21 GMT

Hi @mani55 ,

Firstly let me know whether you want the field value of cmdb_ci to go to user_input or you want the other way round.
If you want the cmdb_ci value to flow to user_input , replace your 5th line with the below line:

ga.user_input = ga.cmdb_ci.getDisplayValue();

I've already tried this in my instance, and it works.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Re: Using fix script same table we need to copy from one field to other field

Renat Akhmedov — Wed, 26 Nov 2025 13:09:18 GMT

Hi @mani55, if the above script from @Sarthak Kashyap will not work (but I hope it will work) - try this one,

var ci = new GlideRecord('cmdb_ci'); ci.addQuery('name', gr.getValue('user_input')); ci.query(); if (ci.next()) { gr.setValue('cmdb_ci', ci.getUniqueValue()); gr.update(); }

I hope it helps, and if it was helpful, please vote with thumbs-up, thanks.

Best regards,
Renat Akhmedov

Re: Using fix script same table we need to copy from one field to other field

Ankur Bawiskar — Wed, 26 Nov 2025 13:10:14 GMT

@mani55

it will only work if both the field type is same

user_input and cmdb_ci both refer to same table?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Re: Using fix script same table we need to copy from one field to other field

mani55 — Thu, 27 Nov 2025 03:02:11 GMT

User input field is string field but cmdb_ci field is reference field so we can get copy from that

Re: Using fix script same table we need to copy from one field to other field

Sheldon Swift — Thu, 27 Nov 2025 03:45:50 GMT

Hi @mani55 - Where is user_input coming from? I would have serious reservations about matching on text input since CI names aren't necessarily unique, but technically something like this should work:

// Instantiate GlideRecord var ci = new GlideRecord("cmdb_ci"); // Get the name of the display field var ciDisplayName = ci.getDisplayName(); var policyException = new GlideRecord('sn_compliance_policy_exception'); policyException.addEncodedQuery('policy=87420b0bc3ef71103cbbfb1f0501317b^cmdb_ciISEMPTY'); policyException.query(); while (policyException.next()) { // Query cmdb_ci for a match if (ci.get(ciDisplayName, policyException.getValue('user_input'))) { // If there's a match, set cmdb_ci policyException.cmdb_ci = ci.getUniqueValue(); policyException.update(); } }

Re: Using fix script same table we need to copy from one field to other field

mani55 — Thu, 27 Nov 2025 04:32:41 GMT

i tried with below script but it's not working

// Instantiate GlideRecord var ci = new GlideRecord("cmdb_ci_pc_hardware"); // Get the name of the display field var ciDisplayName = ci.getDisplayName(); var policyException = new GlideRecord('sn_compliance_policy_exception'); policyException.addEncodedQuery('policy=87420b0bc3ef71103cbbfb1f0501317b^cmdb_ciISEMPTY'); policyException.query(); while (policyException.next()) { // Query cmdb_ci for a match if (ci.get(ciDisplayName, policyException.getValue('user_input'))) { // If there's a match, set cmdb_ci policyException.cmdb_ci = ci.getUniqueValue(); policyException.update(); } }

Re: Using fix script same table we need to copy from one field to other field

soumyadeep10 — Thu, 27 Nov 2025 04:38:06 GMT

@mani55 Could you please clarify which field you want to populate from which. User input value from cmdb_ci or vice versa.

Re: Using fix script same table we need to copy from one field to other field

mani55 — Thu, 27 Nov 2025 04:54:20 GMT

we have this two fields like cmdb_ci field and user input we have in sn_compliance_policy_exception table . already we have value in user_input table and it's string field . cmdb_ci is refrence field and it's refereing cmdb_ci_pc_hardware table what we need is we need copy from user_input to cmdb_ci field in sn_compliance_policy_exception table

Re: Using fix script same table we need to copy from one field to other field

soumyadeep10 — Thu, 27 Nov 2025 05:22:26 GMT

Hi @mani55 ,

Please try the below script, it's working for me:

(Change the field names accordingly if required)

var ga=new GlideRecord('sn_compliance_policy_exception'); ga.addEncodedQuery('policy=87420b0bc3ef71103cbbfb1f0501317b^cmdb_ciISEMPTY'); ga.query(); if (ga.next()){ var gN = new GlideRecord('cmdb_ci_pc_hardware'); gN.addQuery('name', ga.user_input); gN.query(); if (gN.next()) { ga.cmdb_ci = gN.sys_id; ga.update(); } }

Re: Using fix script same table we need to copy from one field to other field

Deepak Shaerma — Thu, 27 Nov 2025 06:08:05 GMT

Hi @mani55

Simply use this script:

var ga = new GlideRecord('sn_compliance_policy_exception'); // 1. Ensure the query is actually finding records ga.addEncodedQuery('policy=87420b0bc3ef71103cbbfb1f0501317b^cmdb_ciISEMPTY'); // Optional: restrict row count for testing // ga.setLimit(10); ga.query(); while(ga.next()){ // 2. Ensure 'user_input' actually has data to copy if(ga.user_input){ // 3. Make sure Workflow/Business Rules don't block this ga.setWorkflow(false); ga.autoSysFields(false); // 4. Copy the value ga.cmdb_ci = ga.user_input; ga.update(); } }

Happy to help! If this resolved your issue, kindly mark it as the correct answer and Helpful and close the thread so others can benefit too.

Warm Regards,

Deepak Sharma

Community Rising Star 2025

Re: Using fix script same table we need to copy from one field to other field

soumyadeep10 — Thu, 27 Nov 2025 06:14:16 GMT

@mani55

Kindly check my response, this working as expected for me:

(Change the field names accordingly if required)

Re: Using fix script same table we need to copy from one field to other field

mani55 — Thu, 27 Nov 2025 12:07:18 GMT

i checked background script it's not showing any thing

var ga=new GlideRecord('sn_compliance_policy_exception'); ga.addEncodedQuery('policy=87420b0bc3ef71103cbbfb1f0501317b^cmdb_ciISEMPTY'); ga.query(); while(ga.next()){ gs.print('the rowa'+ga.getRowCount()); var gN = new GlideRecord('cmdb_ci_pc_hardware'); gN.addQuery('name', ga.user_input); gN.query(); if (gN.next()) { //gs.print('the rowa'+gN.getRowCount()); ga.cmdb_ci = gN.sys_id; ga.update(); } }

Re: Using fix script same table we need to copy from one field to other field

soumyadeep10 — Thu, 27 Nov 2025 12:21:59 GMT

@mani55

The script is working perfectly fine for me.
1. Check whether the Encoded query you have given is right or not and whether it successfully picks any record or not.

2. Check whether any cmdb_ci_pc_hardware record exists with the same name which the user input field has. If not, then the scriptwont work.

For me after execution:

Re: Using fix script same table we need to copy from one field to other field

mani55 — Fri, 28 Nov 2025 07:43:33 GMT

Hi i Used below script in fix script after that i am checking in list view cmdb_ci value is not displaying but when i open any single record i checked that record XML cmdb_ci value showing

our script related XML:

manual update record

Re: Using fix script same table we need to copy from one field to other field

soumyadeep10 — Fri, 28 Nov 2025 09:34:15 GMT

Hi, you didn't change anything in the script I gave you right ?
For me it works fine, the record comes up in the cmdb_ci field correctly. Also one thing, you are sure right that the input provided in the user_input field is the name of the cmdb_ci item ? if the name doesn't match then the cmdb_ci wont get populated.