The ability for metrics to send notification is a good thing but it's very cumberstone to manage since the administrator has to pick and choose who exactly is to be notified when a trigger is met. It would be more efficient for the system to have the ability to use SQL statements to find emails based on a criteria. For example the following types of notifications would really benefit in these use cases:

1. Project team notification use case - setup a SQL statement to find emails from the team table where it's tied to a project met in the metric who are current and are vendors or have a role like 'stakeholder' to alert them of items that are behind schedule.

2. Contact Tracing use case - setup a sql statement to find emails based on the visitors and employees who have hotelled a space or had a reservation as of last 10 days because they now all are encouraged to get a covid test.

3. Compliance events - the issue right now is the compliance notifications are also based on naming a person one at a time, it would be nice if that was SQL based so we can find the email based on the responsible person to an event that triggered the alert.

in order for the system to do this, the system would benefit from showing a list of fields/tables used in the metrics that it can leverage to do a query on.

There are many other use cases so I encourage others to add uses where you want the system to be able to find the right person to email and not the administrators naming exact people to email.