Page MenuHomePhabricator

Make it easy to query tasks for new project requests for translatewiki.net (create a new subproject?)
Closed, ResolvedPublic

Description

Language-Team has a quarterly goal to track how quickly we process new project requests for translatewiki.net. As an approximation for that, we would like to calculate the days between task creation and task closure. We found out a workflow where we can export as CSV search query results. We however cannot target search query to a specific column. Hence we were thinking of creating a sub project for translatewiki.net (#translatewiki.net-new-projects) so that we would not need manually pick the relevant tasks from the search results.

If you know better ways to get this date, that would be okay as well.

Event Timeline

I assume this is about the New projects for translation column on the translatewiki.net workboard.

https://phabricator.wikimedia.org/conduit/method/project.query/ lists "phid": "PHID-PROJ-enafjwga6broag7fy35z" for "name": "translatewiki.net".

Then, https://phabricator.wikimedia.org/conduit/method/project.column.search/ lists "phid": "PHID-PCOL-7exoct64a4b2w2r2lair" for "name": "New projects for translation" after passing {"projects":["PHID-PROJ-enafjwga6broag7fy35z"]} as constraints.

Then, https://phabricator.wikimedia.org/conduit/method/maniphest.search/ allows passing that as columnPHIDs.

So in theory you could run queries restricted to items in a specific column.

DannyS712 renamed this task from Make it easy to query tasks for new project requests for translatewiki.net (create anew subproject?) to Make it easy to query tasks for new project requests for translatewiki.net (create a new subproject?).Dec 23 2020, 12:11 AM
Nikerabbit claimed this task.

No longer tracking this, but the tips are helpful.