How to copy values from one column field value to antoher column field value?

manojpanda
Giga Contributor

find_real_file.png

Hi Developers,

How can i copy caller field value to priority/state value.

Here in caller field Suppose Abel Tutor has to copy to state filed. How to achieve this?

1 ACCEPTED SOLUTION

Hey manojpanda



Yes it is possible with fix script, Now you are on track and i have already created fix script in my PDI and it's working for me.



Please follow my steps:



Step-1: Navigate to Fix Script ==> System Definition ==> Fix script and Follow the screen shot


find_real_file.png


Step-2:


Crete New fix script with below script and then save it after that   click on Run Fix Script as like mentioned in below screen shot:



var gr = new GlideRecord('incident');  


gr.EncodedQuery('short_description=NULL');  


gr.addQuery();


gr.query();


  while(gr.next())    


{  


var copy1 = gr.getDisplayValue('category');  


gr.setValue('short_description', copy1);


gr.update();   //Save it  


}  



Follow Below screen shot


find_real_file.png



Step-3: Finally Category copied to shot description, final result incident short description updated in below screen shot


find_real_file.png



I hope this will be helpful to you and Please Hit Like and Helpful & Correct Answer




Thanks,
Rajashekhar Mushke
Rising star : 2022 - 2024
Community Leader -2018
Connect me on LinkedIn : Rajashekhar Mushke

View solution in original post

10 REPLIES 10

Exactly... this is the real risk of community.   Already there's been a ton of proposed answers and we dont' even now what the requestor is trying to accomplish yet.


Need some more context.   When do you want the category value to be placed in the short description?   Immediately after someone populates the category on the client side?   Or after the recrod is saved?   Or maybe you have a whole bunch of them already and you want to do it via some kind of update script?


Hey manojpanda



can you please close this thread, then only this will be helpful for other community users.



If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.


If you are viewing this from the community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View




Thanks,
Rajashekhar Mushke
Rising star : 2022 - 2024
Community Leader -2018
Connect me on LinkedIn : Rajashekhar Mushke

Mrigank Gupta
Giga Expert

It doesnot make much sense in doing this.


Caller field is a reference field on User table and priority is just a string one.


Rajesh Mushke
Mega Sage
Mega Sage

Hey Panda,



There is no use of doing this, because Priority will populate based on Impact and Urgency and Caller field Referencing to User(sys_user) table.




Thanks,
Rajashekhar Mushke
Rising star : 2022 - 2024
Community Leader -2018
Connect me on LinkedIn : Rajashekhar Mushke