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"}