Various notification queries

Method : POST

URI : /db/<db_name>/query

Body :

{"sql":"<sql query...>"}

• List of all registered notification templates
{"sql":"select * from reg_notif"}

• List of all notifications for a registered notification template
{"sql":"select * from notif where notifid = <id>"}

• List of all open notifications
{"sql":"select * from notif where openflag = 1"}

• Count of all notifications for a given notification id
{"sql":"select count(*) from notif where notifid = <id>"}

• Count of all open notifications
{"sql":"select count(*) from notif where notifid = <id> and openflag = 1"}