hi , Ive a use case to update all the script recor...
# suitescripts
shree sashti
02/19/2025, 10:54 AMhi , Ive a use case to update all the script record's owner to a different user (a notification group ) . Is there a way to update in bulk? any scripting solution ? Kindly advice
n
NElliott
02/19/2025, 12:02 PMUpdating the owner or updating who is notified when the script errors?
s
shree sashti
02/19/2025, 12:05 PMWe donot want the script owners to be the past employees of the organisation. So wanted to update the owner
n
NElliott
02/19/2025, 12:19 PMYou can update the owner field to the employee you need.
You can do this easily enough with a search / query and iterate the results using submitFields to set the "owner"
NElliott
02/19/2025, 12:22 PMSimple search to identify those scripts where the owner is "1234"
Copy code
const scriptSearchObj = search.create({
type: "script",
filters:
[
["isinactive","is","F"],
"AND",
["owner","anyof","1234"]
],
columns:
[
search.createColumn({name: "internalid", label: "Internal ID"}),
search.createColumn({name: "owner", label: "Owner"})
]
}); Copy code
record.submitFields({
type: 'script',
id: the_Record_Internal_ID,
values: {
owner: the_Updated_Employee_ID
}
});s
shree sashti
02/19/2025, 3:30 PMThanks @NElliott, let me try this
n
NElliott
02/19/2025, 3:38 PMYou could try it with one record to start with in the console / debugger. I tried it directly loading a script record and updating it myself it worked fine, I see no reason why the approach above would not work for you.
3 Views