Page MenuHomePhabricator

Moving a task to a parent project via non-workboard methods does not remove it from milestone columns
Closed, ResolvedPublic

Description

I completely understand if I did this incorrectly, but here's how you can reproduce what I did.

  • Create Project A
  • Create Milestone 1 under Project A
  • Create a workboard for Project A and add some tasks to the Milestone 1 column
  • Decide that you don't want milestones, but named columns
  • Archive Milestone 1 (without moving the tasks to Backlog first because I guess I went braindead)
  • Use the maniphest advanced search to search for all the tasks that still have the archived Milestone 1 tag
  • Bulk edit these tasks to remove Milestone 1 tag and add Project A tag (my thought process was that this would stick them in the Backlog column on Project A's board)
  • Go browse Project A's board and see nothing in the backlog
  • Manually browse to one of the tasks and see that it is still in the Milestone 1 column of the Project A workboard (projects got replaced but column stayed?)
  • Manually edit the task and remove Project A and save. Re-edit the task and add Project A back. This still displays Milestone 1.

Now, I can manually visit all of these tasks and do the Move on Workboard action but that's a pain. Is there a query I can run assuming I know all the task/project phids to update the workboard column?

Also, how should I have done this the right way?

Here's my version info:

phabricatorf73b0f0e2cb3bd07b7b4d961059cdec0c8983dc2 (Thu, Jun 2)
arcanist0249f90a9a4aa42da0823673a6ac8c620251d82a (Fri, May 20)
phutil533641b548de8b8c1e681db4484b71cb8a6c04fc (Thu, Jun 2)

Event Timeline

Will the following work to fix this?

UPDATE project_columnposition SET columnPHID = 'phid_of_backlog_column' where columnPHID in (milestone_column_phids)

Confirm bug that is, no idea about SQL query.

chad renamed this task from Oddness with archiving milestones to Batch Editor doesn't assign parent project if task already exists in Milestone.Jun 3 2016, 7:58 PM
chad added a project: Maniphest.
epriestley renamed this task from Batch Editor doesn't assign parent project if task already exists in Milestone to Moving a task to a parent project via non-workboard methods does not remove it from milestone columns.Jun 5 2016, 11:01 PM
epriestley claimed this task.
epriestley triaged this task as Normal priority.

This also reproduced with normal "Edit Projects", it wasn't specific to the bulk editor.

That SQL should be fine to fix it. You can also just delete those position rows entirely and the tasks will be moved to the backlog on the next load of the workboard.