"Easy pickings unset" is confusing lots of people

[Luke Plant]

People keep getting the message "Easy pickings unset" after making a change on a ticket, and then they get confused, and sometimes they come back and 'revert' e.g.

https://code.djangoproject.com/ticket/7028#comment:58

Can someone with server access run a query to set all the NULLs for that flag to 0 or whatever the value should be?

(It is possible to do it with the batch modify interface and a query like this: https://code.djangoproject.com/query?status=!closed&easy=!1&easy=!0

But then my name will be on 1296 open tickets, which is a pain because, although I read django-updates anyway, getting e-mail personally about every ticket will break the email filters I have which currently can distinguish between django-updates and the tickets that I've actually been involved in).

[Luke Plant]

And the UI/UX flag while we are at it.

[Ramiro Morales]

... and now we have a similar problem with the new UI/UX flag :)

[Aymeric Augustin]

Moving to RFC — this isn't a ticket the community can act upon.

[Aymeric Augustin]

Given Trac's database schema, this isn't trivial to do in the database:

code.djangoproject=> select name, value, count(ticket) from ticket_custom group by name, value order by name, value;
        name        |         value          | count 
--------------------+------------------------+-------
 easy               | 0                      |  2681
 easy               | 1                      |   480
 easy               |                        |    13
 has_patch          | 0                      |  9242
 has_patch          | 1                      |  8136
 needs_better_patch |                        |     2
 needs_better_patch | 0                      | 15589
 needs_better_patch | 1                      |  1193
 needs_better_patch |                        |     2
 needs_docs         |                        |     2
 needs_docs         | 0                      | 16199
 needs_docs         | 1                      |   583
 needs_docs         |                        |     2
 needs_tests        |                        |     2
 needs_tests        | 0                      | 15826
 needs_tests        | 1                      |   956
 needs_tests        |                        |     2
 stage              | Accepted               |  5284
 stage              | Design decision needed |  1299
 stage              | Fixed on a branch      |    41
 stage              | Ready for checkin      |  2403
 stage              | Someday/Maybe          |   113
 stage              | Unreviewed             |  8238
 ui_ux              | 0                      |  2567
 ui_ux              | 1                      |   146
 ui_ux              |                        |    12
(26 rows)

One would have to insert a row in this table for every ticket number, unless there is one already.

---

However, the way the tracker notifies contributors has changed since this ticket was opened. I think it's now possible to do it with the "batch modify" plugin without side effect.

I've done that, except that I managed to mix easy and ui_ux, but fortunately I could recover the list of tickets where I had accidentally unset ui_ux, and set the flag again in batch.