Few options from the top of my head...
Option 1 - Drilldown capability in Madrid
If you are using the Madrid release you can take advantage of the new drilldown capability, so, as an example, if you keep using the em_alert table you can group and drill down based on task number:
Create a simple report on em_alert and group by task->number
Click on the new report structure button and then on the add drilldown button:
Select the criteria for your drilldown, in this example em_alert data shown on a list widget:
Grouping on Task->number
When you click on the desired task number you can see the associated alerts:
Option 2 - Incident table
If you still want to start from the incident table you could do something similar but less nice (staying in the realm of simple reports), you could use relatedlist conditions and select Alert->Task:
Then from here you can drill down from incidents into alert via the form:
Option 3 - For the highest control you can use database views.
I hope this helps,
Gp
Few options from the top of my head...
Option 1 - Drilldown capability in Madrid
If you are using the Madrid release you can take advantage of the new drilldown capability, so, as an example, if you keep using the em_alert table you can group and drill down based on task number:
Create a simple report on em_alert and group by task->number
Click on the new report structure button and then on the add drilldown button:
Select the criteria for your drilldown, in this example em_alert data shown on a list widget:
Grouping on Task->number
When you click on the desired task number you can see the associated alerts:
Option 2 - Incident table
If you still want to start from the incident table you could do something similar but less nice (staying in the realm of simple reports), you could use relatedlist conditions and select Alert->Task:
Then from here you can drill down from incidents into alert via the form:
Option 3 - For the highest control you can use database views.
I hope this helps,
Gp
