3.24.7. GetSubscriptionQuery Previous topic Parent topic Child topic Next topic

An SQL statement to get a 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 GetSubscriptionQuery is defined as an empty string, then the query will not be executed.
%0 and %1 are undefined.
GetSubscriptionQuery defaults to:
SELECT * FROM SUBSCRIPTIONS WHERE tenant_id=%2 AND (name=%4 OR id=%3)