Using custom settings

You can reference custom settings in load queries and in SQL scripts.

To manage custom settings, select Dashboards > Applications Administration > Custom Settings.

Use this syntax to reference a custom setting::

@CustomSettings.<custom_setting_name>

Example

SELECT firstname, lastname, age, department
FROM Employees
WHERE department =@CustomSettings.cs_Department