Update Bulk change request at once uing catalog

[AshishKumaG]

Suppose there are 10k change request data and we want to close all the data at once using a catalog. Is possible to update the 10k data at once using catalog

[vaishali231]

hey @AshishKumaG 

Yes, it can be done, but a Catalog Item is not the best way to directly close 10,000 Change Requests.

Catalog requests usually run in a single transaction, so if we try to update 10k records from the same request, it can easily hit timeout / performance limits and the update may fail halfway.

If you really want to use a catalog item, the better approach is  ---

Use the catalog item only to capture the input (filter / criteria)

Trigger a backend job (Scheduled Job / Fix Script / background process)

Close the changes in batches (ex: 200–500 at a time)

That way it won’t overload the instance and you can track progress properly.

*************************************************************************************************************
If this response helps, please mark it as Accept as Solution and Helpful.
Doing so helps others in the community and encourages me to keep contributing.

Regards
Vaishali Singh

[Aditya_hublikar]

Hello @AshishKumaG ,

Yes, it is technically possible to update or close 10k Change Requests via a Catalog Item, but it is not recommended because catalog transactions run synchronously and may hit performance limits.

You can update bulk records by Data management  (without any scripting)

Go to target table => filter out data which you want to delete ( apply OOTB filter functionality) =>Right click => In Context Menu => click on Data management => click on Update with all preview => open another forms, enter the fields value which you want to update => save form => then there is execute now related link , click it => All filtered out records will get updated.

If this helps you then mark it as helpful and accept as solution.

Regards,

Aditya

[Aditya_hublikar]

Hello @AshishKumaG ,

I hope you are doing well . Does my response helps you ?

If my response helps you then mark it as helpful and accept as  solution.

Regards,

Aditya

[its_SumitNow]

Hi Ashish

Via Scripting you can do anything on the platform, but it is not feasible, Service Catalogs are designed for requesting  item, not for managing the data, I hope you are getting ashish , But still if you have any official requirement somewhat related to your question, then we can discuss further

If my response helped, kindly mark it as helpful. & accept as Solution 🙂

Warm Regards

Sumit

Technical Consultant