1066371 - Add fields needed in ES for reviewer tools queues

Status: RESOLVED FIXED

(Marketplace Graveyard :: Reviewer Tools, defect, P4)

Description

[Rob Hudson [:robhudson]]

Come up with fields needed to move reviewer tools to elasticsearch and add them to the index and indexing code.

Comment 1

[Rob Hudson [:robhudson]]

The following fields will need to be added. I'm using the proposed paths in the ES document for naming here:

* priority_review (used for app_flags)
* num_abuse_reports (displayed in the queue)
  - I'm curious how important this is to stay current (index when it changes) vs doing a db query for this or even if it's an important column in the queue.
* is_rereviewed (like is_escalated, will be used for re-review queue)
* latest_version.nomination_date (for sorting)
* latest_version.created_date (for sorting, fallback if nomination doesn't exist)

I haven't looked into the special queues (tarako, China queue) or the moderated reviews.

Comment 2

[Rob Hudson [:robhudson]]

https://github.com/mozilla/zamboni/commit/186a110 

I'll close. When implementing the other queues if any field is missing we can add it along with those bugs.