3.24.3. GetServiceQuery Previous topic Parent topic Child topic Next topic

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