Reporting on Articles without translated versions

[Mike D3]

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!

[James Chun]

Hi @Mike D3,

Haven't tested this out because I don't have multi-language enabled, but can you try the below?

Of course, you can modify the conditions to meet your requirements but this should give the English articles where it doesn't have 4 translated articles.

Hope that helps, cheers

[Mike D3]

This is super interesting in that I have never even really used the Related List Conditions option in reporting! Your proposed solution does not work for me as I do not have a related Translated From list available. The only "*translated" related lists to my kb_knowledge are regarding Translation Tasks.

Of course I am going to go on the hunt for the list you reference in your screen shot!

Thank you for the response even though this does not seem to work in my instance.

[James Chun]

No worries, my understanding is that the Translated from field is used to map the relationship between the original and translated article.

Did you modify the label by any chance or are you using a different field to map the relationship?

You mentioned the parent/child relationship and a parent field which I assume is a custom field. 

If you are using this field to map the relationship, you should be able to use that field in the Related conditions. 

However, do note that this is not an OOB way of translating articles and I would advise reverting the customization out if possible.

Cheers

[Mike D3]

As far as I am aware we are using the OOB capabilities, no customization for this process (including labels AFAIK).