Derived distros diffs pages need a more comprehensive search

[Julian Edwards]

We need to be able to search on:
 * packagesets
    'is in LIST'
    'is not in LIST'
    'is in LIST and not in LIST' ?
 * package uploader/maintainer name
   fuzzy matching needed, or use the person vocab to select a person and use an exact match ?
 * optionally package name substring
   this may be tricky to implement - will depend on the exact data model.

[Robert Collins (lifeless)]

I've updated the description with some basic notes; will try to catch up with julian soon and/or check the schema.

[Julian Edwards (julian-edwards)]

Having a conversation in the description is a bit weird so I'll follow up here like normal ;)

For packagesets, 'is in LIST' or even a simple 'matches ITEM' will suffice.

For package uploader/maintainer name, using a vocab is fine.

For substring on package name, we are searching across DistroSeriesDifference, which has a FK to SourcePackageName and we want "SPN.name LIKE %criteria%'

[Robert Collins (lifeless)]

Ok, they all should be fine for quite a while. Be sure to test
performance as we go, just in case :)

[Julian Edwards (julian-edwards)]

see also bug 798873

[Julian Edwards (julian-edwards)]

See bug 798904 which talks about sorting results.

[Julian Edwards (julian-edwards)]

Duped to a better bug. Packageset searching is already done.