In the documentation there are only parameters. The database connection is clear, but how does the QueryTemplate parameter work? How do I write a custom notification to the table?
QueryTemplate is the actual sql query, where ? sign works as macro, it's first occurrence is replaced by recipient and second by message body. E.g.:
QueryTemplate=insert into notifications values (?, ?);