3.24.8. UpdateSubscriptionQuery Previous topic Parent topic Child topic Next topic

An SQL statement to update an existing subscription. Special formatting characters may be used. Special variable %2 contains a tenant id, %3 contains object's id and %4 contains object's name. If UpdateSubscriptionQuery is defined as an empty string, then the query will not be executed.
%0 contains list of subscription key=value pairs and can not currently be used as a SQL bind parameter. %1 is undefined.
UpdateSubscriptionQuery defaults to:
UPDATE SUBSCRIPTIONS SET %0 WHERE tenant_id=%2 AND id=%3