Inactive Knowledge Article Author replaced with Knowledge Base Manager

[Community Alums]

Hello Developers,

How would I go about making it to when a Knowledge Article Author (sys_user) becomes inactive, that knowledge article author is replaced with the knowledge bases' manager?

Thanks in advance!

[Uncle Rob]

You could use a Flow Designer.

TRIGGER
- Record Updated in User table where active changes to false.

1)  Look Up Records:  knowledge table where author = trigger's user
2) For each of (1)
3)  Update Record of (2)
- set author = the knowledge article's knowledge base's manager.

[Community Alums · Accepted solution]

Hi,

I have created a video for you to guide to write a Business Rule for this requirement. Please let me know if you have further questions.

Please mark this comment as Correct Answer/Helpful if it helped you.

Cheers,

Hardit Singh

[Community Alums]

Thanks for the help and the very detailed video.

It worked great!

[Vijay Baokar]

Hi @Community Alums thanks for tis video its really useful case. I have 1 qst.

Suppose there are 250 active articles which has inactive user (not same user), i need to clean up such data and replace all those inactive authors with their manager. this will be a one time activity.