Anomie added a comment.
At the database level, you should be able to detect RC entries that changed a
particular slot easily enough, by including a join like
JOIN slots ON (rc_this_oldid = slot_revision_id AND slot_role_id = ? AND
slot_origin = slot_revision_id)
If you want to allow for "touched any of multiple slots", that would probably
need an EXISTS. I forget the exact semantics of `slot_origin`, that may or may
not find reverts.
You could also exclude changes that touched any particular slot or slots, like
LEFT JOIN slots ON (rc_this_oldid = slot_revision_id AND slot_role_id IN
(?) AND slot_origin = slot_revision_id)
WHERE slots.slot_revision_id IS NULL
The potential problem with any of these is performance, particularly in
situations where few or no edits pass the filter (cf. T97797
<https://phabricator.wikimedia.org/T97797>). Although we already have such
problems with other RC queries, so one more may not be a huge deal.
TASK DETAIL
https://phabricator.wikimedia.org/T230862
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Cparle, Anomie
Cc: EBernhardson, Cparle, dcausse, Anomie, daniel, Aklapper, Lydia_Pintscher,
Tgr, Ramsey-WMF, Addshore, Tpt, Lucas_Werkmeister_WMDE, Smalyshev, Hook696,
Daryl-TTMG, RomaAmorRoma, 0010318400, E.S.A-Sheild, darthmon_wmde, WDoranWMF,
Meekrab2012, joker88john, DannyS712, CucyNoiD, Nandana, NebulousIris, JKSTNK,
Gaboe420, Versusxo, Majesticalreaper22, Amorymeltzer, Giuliamocci, Adrian1985,
Cpaulf30, Lahi, PDrouin-WMF, Gq86, Af420, E1presidente, Darkminds3113,
Anooprao, SandraF_WMF, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382,
Th3d3v1ls, Ramalepe, Liugev6, QZanden, EBjune, Tramullas, Acer, merbst,
LawExplorer, Sethakill, Salgo60, WSH1906, Lewizho99, Maathavan, Silverfish,
dg711, Poyekhali, _jensen, rosalieper, Taiwania_Justo, Jonas, Xmlizer,
Susannaanas, Ixocactus, Wong128hk, Jane023, jkroll, Wikidata-bugs, Jdouglas,
Base, matthiasmullie, aude, Tobias1984, El_Grafo, Dinoguy1000, Manybubbles,
jayvdb, Ricordisamoa, Wesalius, Fabrice_Florin, Raymond, Jdforrester-WMF,
Steinsplitter, Mbch331, Keegan, Legoktm
_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
