how do i update the company field for multiple CI's all in one hit

sanjaypanchasra
Kilo Explorer

I am having to click and go into each CI and update the company field individually - for over 100 CI's this is tedious and a pain - there must be a way to select all CI's and update the company field all in one go.

any ideas of how to do this?

6 REPLIES 6

david_legrand
Kilo Sage

option 1: list edit (like excel), the "control" key (or "shift" key as you prefer) is your best friend : Edit multiple records in a list using the list editor


option 2: do a fix script?


option 1 is good if all the records you want to edit are in the list. If you want to edit multiple records even ones that aren't currently shown, use option 3: Edit multiple records in a list using an editing form


Update all records in the list
  1. Filter the list so it contains only the rows you want to edit.
  2. Perform the appropriate action for the list version:
    • List v3: Open the list title menu and select Update All.
    • List v2: Right-click any column header and select Update All.

Editing Multiple Records


zica
Giga Guru

Sanjay,



you can writ a fix script and GlideRecord the CI and update the company name ;


Here is a sample of the script, change it as your requirements : I have made a script for a mass update of the country name in location table:



var country = new GlideRecord("cmn_location");


country.addQuery("country","CONTAINS","SHA: Out of the Box");


country.query();



while(country.next()){


country.country = country.u_country.getDisplayValue();


country.update()


}



Not : change the table name and also the addQuery to extract the correct value


avinash kumar
Tera Expert

Hi,



You can use the list edit feature.



Go the left navigation panel and click on the configuration item. It would list all the items.


Apply filter criteria so that you have narrowed down the result.


Next, click on the gear icon and bring the company field in the list.



Next, go to the company part in the first record while holding shift and arrow downm you can select all such records and then click on the first record, while doing so, it will make the field editable and a messgae that the update will impact X number of records. Update with the desired value and click on tick mark.



This feature is called list edit.



Regards,


Avinash