#289 Create scheduled job in vista indexor to find missed archived tasks

[Adam Tauno Williams]

The vista indexer uses the event bus to received notifications and regenerated related search vectors. This also toggles a vector as beloging to an archived object, or not. Recently a bug was fixed where archive events were not making it onto the event bus - that is fixed - but archived/not-archived is significant for tasks. A scheduled task to check for any missed-archived is easily to implement and avoids putting archived tasks in non-archived search results.

UPDATE vista_vector SET archived = true
WHERE object_id IN (
  SELECT object_id
  FROM vista_vector v
    INNER JOIN job j ON (j.job_id = v.object_id)
  WHERE v.archived = false 
    AND v.entity = 'task'
    AND j.job_status = '30_archived')