Score:0

how to select for revisions of one language?

za flag

the node revision delete module do not distinguish the language of the revisions.

The sql query for candidate revisions of each node is :

SELECT t.vid AS vid
FROM
(SELECT r.vid AS vid, r.revision_timestamp AS revision_timestamp
FROM
node_field_data n
INNER JOIN node_revision r ON r.nid = n.nid
WHERE (n.nid = '7459') AND ("changed" < '1644848132') AND ((n.vid > r.vid))
GROUP BY n.nid, r.vid, r.revision_timestamp
ORDER BY "revision_timestamp" DESC
LIMIT 9223372036854775807 OFFSET 4) t

i can retrieve the active languages of the site

 // Getting the list of enabled languages
    $langcodes = \Drupal::languageManager()->getLanguages();
    $langcodesList = array_keys($langcodes);

I did not find how to iterate that query for each languages, selecting each time only the revisionf for that language

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.