Business Rule to update Affected CI related list of a change request submitted via record producer

[JC S_]

We created a record producer for change requests. We need to tag multiple CI and the way we determined for this is using the Affected CI related list. However we can't populate it by mapping a list collector as such we were advised to use a business rule that will update the related list after insert or async. Can anyone share how we can achieve this?

[Rajesh Annepak1]

Hi JC,

Hope I understood correct

You have an Affected CI List Collector field on the Record Producer and Once you have the values and submitted the record producer these affected CI's Should be moved to " Affected CI Related List " Under the change request record

Is my Understanding correct ??

[JC S_]

That is correct.

[Rajesh Annepak1]

Hi JC,

Please follow the below steps , I know there might be other ways to implement this task , But as of now iam going with this approach

1. Create a dummy field on the change_request   table and data type is string

2. Under the record producer Script : get the values from the list collector By using producer like producer.list_Collector database name

3. map the list collector values to your dummy field on the change request table

4. Write a Before Insert Business rule

5.In the Business rule read the string from the dummny variable by using an array

6. GlideRecord to the task_ci table

7. Create individual records for each sys_id

8.

You can see in the task field give the currrent.sys_id variable

9. in the Configuration item field pass the sys_id that you have retrieved from the dummy variable

Please let me know if you need sample script

And Also Please mark helpful / Correct I fyour query is resolved

Rajesh kumar Annepak

[Suraj Sharma]

Hi @JC S_ ,

Can you tell me that how you are populating Affected ci in The list collector field