Reporting on Articles without translated versions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2024 11:06 AM
Long time lurker, first time poster - fingers crossed and thanks in advance for any help anyone can contribute.
In our instance we leverage parent/child translations. We have added a Country field to all articles, treating all English articles labelled as Global to be the Parent article which needs to be translated into all 4 non-English languages we support (Japanese, Malay, Traditional Chinese, Simplified Chinese).
Problem statement: Knowledge governance would like a report/dashboard that alerts them to any Published, Global English article that is not translated into all expected languages (or none at all). So I need to be able to show them, for all Published/English/Global articles, all gaps where that article does not yet have Published Child articles in all of those 4 languages listed above. I have looked at kb_2_kb and I have attempted using Interactive Analysis on kb_knowledge. I just can't get to a report for the absence of required child articles. I would prefer to keep users in ServiceNow and find a way to integrate this information on a dashboard for them.
I have created a List report off of kb_knowledge (reporting off the Parent field), grouped by Parent that indicates how many translated versions there are but it's clunky, ugly and does not indicate where there are 0 translated versions...
Any help would be greatly appreciated!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-27-2025 03:53 AM
Parent is the name set in the old releases to map the relationship between the original and translated article, starting from Tokyo (not sure 100%) SN renamed that field to Translated from.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-24-2024 02:49 AM
Hello Mike D3
With the "convention" that English is always the original article, we have setup this report able to list all published articles and related existing translations .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-24-2024 05:44 AM
I have done similar (glad we are on the same page)... you are using the Pivot Table report for this? Does this catch articles that have no published translations?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-24-2024 07:27 AM
Pls look the picture
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-24-2024 08:01 AM
Yes, thank you. What is the behavior when the Parent article has zero translated versions? I was guessing it would not show up on that chart at all. Is that correct?