3.24.6. AddSubscriptionQuery Previous topic Parent topic Child topic Next topic

An SQL statement to add a new 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 AddServiceQuery is defined as an empty string, then the query will not be executed.
%0 and %1 are replaced with subscription parameter names and their values, respectively, and can not currently be used as SQL bind parameters.
AddSubscriptionQuery defaults to:
INSERT INTO SUBSCRIPTIONS (%0) VALUES (%1)