santhosh added a comment.
Notes
=====
"My dashboard- all translations I started or collaborated in draft or published
state between any language pair":
Select *
from translations, translators
where translators.translator_translation_id = translations.translation_id
and translators. translator_user_id = $GLOBALUSERID
"Translations started by me":
Select *
from translations, translators
where translators.translator_translation_id = translations.translation_id
and translators.translator_user_id = $GLOBALUSERID
and translations. translation_started_by = $GLOBALUSERID
"My published translations":
Select *
from translations, translators
where translators.translator_translation_id = translations.translation_id
and translators.translator_user_id = $GLOBALUSERID
and translations.translation_status = 'published'
"My draft translations":
Select *
from translations, translators
where translators.translator_translation_id = translations.translation_id
and translators.translator_user_id = $GLOBALUSERID
and translations.translation_status = 'draft'
"Whether this title is being translated between this language pair?"
"Titles being translated between language pair a and b"
"Translations in progress to this language?"
"Who are the translators worked on this translation? Who started, who last
updated?"
TASK DETAIL
https://phabricator.wikimedia.org/T615
REPLY HANDLER ACTIONS
Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign
<username>.
To: santhosh
Cc: wikibugs-l, Arrbee, KartikMistry
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
