How do I find all articles in a certain language?

[Alfa1]

The main language of my wiki is English. I also have other languages like Dutch & German.
I have translators who want to translate my wiki articles. One translator will do the Dutch translations and another will handle the German translation.

How do I show the translators which articles still need to be translated?
How do I show the translators which articles are already translated?
There does not seem to be any overview of articles in a specific language.

I tried to search for the articles a user has contributed to, but the advanced search does not include a field to enter the user. Any other content type in xenforo does have this function.

I need to give the translators a clear list of what they need to do.
Do you have any idea on how to approach this?

[pegasus]

On the front end, I think we need new Special pages to handle this:

- A list of all pages in a selected language
- A list of all pages in a selected language that don't have translations in another selected language

As for searching articles a user contributed to by advanced search, that information is not indexed by XenForo and it would use too many resources if we tried, since a page can have thousands of different contributors. Instead, use Special:Contributions to get a list of all edits by a selected user.

In the AdminCP, I believe you can get a list of all pages in a language through the Mass Management system. For your criteria, only choose a language. For your replacement, enter anything, just don't approve the changes in the next step. The Prepared Results should be a list of only pages in the language.

[Alfa1]

New special pages would be welcome as I need to show it on the front end.

Would it use to many ElasticSearch resources to do a search for all articles a member has contributed to? Are edits in an article not like posts in a thread? Just like you can search for posts and have the results displayed as threads, I would expect that the results would display as Articles. Elastic Handles large threads or multiple millions of posts fine.

[pegasus]

Individual edits are not indexed. While indexing posts is valuable because they contain varied text, edits are generally the same text with slight changes. The only valuable information they would really provide is user information. Basically it is the same problem of adding millions of entries to an index that won't really provide good relevancy information and will slow down normal searches.

Without ballooning the index, it is easier to search for the creator of a wiki page or the last editor, than a random editor in between.

[Alfa1]

Thanks for explaining. That makes a lot of sense. If I want a list of Pages in a Wiki Area that do not have a Dutch translation, can this be done by a query? And can this result in a list of article names?

[pegasus]

The following should result in all wiki pages that don't have a Dutch version, sorted by title. You may need to tweak the output due to the prefix being stored differently than the URL would display it (possibly > vs : ). Also, sortkey is cropped to a certain number of characters in the index. You may not get usable results for entries with very long titles.

In the query below, replace {DUTCH_LANGUAGEID} with the appropriate ID number, which can be found in the Wiki AdminCP language page.

SELECT i.sortkey FROM vw_route AS i
INNER JOIN vw_nodetype AS t ON (t.`id` = i.itemtypeid AND t.accesskey = 'Page')
LEFT JOIN vw_langitem AS c ON (c.pageid = i.itemid)
LEFT JOIN vw_langitem AS l ON ( l.langgroupid = c.langgroupid AND l.languageid = {DUTCH_LANGUAGEID} )
WHERE l.langgroupid IS NULL
ORDER BY i.sortkey ASC