Closed Bug 863764 Opened 11 years ago Closed 11 years ago

Figure out a way for KaiRo's reports to query into raw JSON in the DB

Categories

(Socorro :: Database, task)

Product:
Socorro
Component:
Database
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: kairo, Unassigned)

Details

As we have the raw JSON in the DB now, I'd like to have my reports be able to do queries against it. I'd like to get info like devices or Android versions etc. to put into those reports. I'm using the analyst user atm, which I guess doesn't have access to the raw JSON as that contains stuff like URLs and emails. Also, I'd like to know how to efficiently do queries against fields of that raw JSON once I have access.
Selena, you said on IRC that this data isn't even in the DB yet. Do I get it correctly that bug 866960 is the missing piece that will give us that? If so, I guess we should look into the request in this bug once that has landed in prod.
It is in the DB now and Selena created a DB user for CrashKill people to use with full read access to all data, so this bug is fixed.
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.