KB Approval Notification - How to include KB article fields such as Short Description and Author?

Chase Stevenson
Mega Guru

Hello, we have an approval notification that gets sent out when a KB article is set to published state by the submitting user.

The KB managers have to approve the article before it gets published, else it will revert back to draft.

In the notification, I am unable to call the fields from the KB table such as Short Description, Author, etc.

Notification:

find_real_file.png

When I try to add ${author} or ${short_description} the notification leaves those values blank as it cannot pull them from the [kb_knowledge] table, as the notification is generated from the [sysapproval_approver] table:

find_real_file.png

How do I get the notification to show these fields from the KB article?

1 ACCEPTED SOLUTION

Well this doesn't bode well:

https://community.servicenow.com/community?id=community_question&sys_id=28a84f21db5cdbc01dcaf3231f961994

Looks like you may need to go the mail_script route.

 

View solution in original post

10 REPLIES 10

Shane J
Tera Guru

Instead of  ${author} have you tried ${sysapproval.author} ?

Shane, as far as I know, sysapproval.author is not a valid field as I cannot find "author" in the sysapproval field list.

I did try sysapproval.short_description and sysapproval.opened_by and sysapproval.sys_created_by and still got the same result:

find_real_file.png

find_real_file.png

Ok, how about ${sysapproval.kb_knowledge.approver} ?

 

I'm using this in an e-mail notification and it works:

Here are the request details that were submitted:
Request Made: ${sysapproval.cat_item}
Requested By: ${sysapproval.request.opened_by}
Requested For: ${sysapproval.request.requested_for}, ${sysapproval.request.requested_for.title} in ${sysapproval.request.requested_for.department}

I did try the sysapproval.kb_knowledge but still got the same result:

find_real_file.png

find_real_file.png

find_real_file.png

 

I'm unsure why I can't call the fields from the kb_knowledge table, it was my understanding that the sysapproval.table method was the way to do so.