Add a view on the event_loss_data showing the tag and the rupture ids

Bug #1337869 reported by Michele Simionato
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenQuake Engine
In Progress
High
Michele Simionato

Bug Description

This is useful when investigating an event based calculation.

CREATE VIEW riskr.event_loss_view AS
SELECT event_loss_id, b.tag, c.id AS rupture_id, aggregate_loss FROM
riskr.event_loss_data AS a, hzrdr.ses_rupture AS b,
hzrdr.probabilistic_rupture AS c
WHERE a.rupture_id=b.id AND b.rupture_id=c.id;

Changed in oq-engine:
assignee: nobody → Michele Simionato (michele-simionato)
importance: Undecided → High
milestone: none → 1.0.1
status: New → In Progress
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.