Use system parameters in any data source query or HTTP request for any report. System parameters are predefined input parameters that allow you to refer to variable objects, such as user name. Combine a system parameter with the at symbol (@) to use it in a query.
|
System Parameter |
Description |
Example |
|---|---|---|
|
sys_userid |
Identifier for the logged-in user. You can use this parameter to filter the data report users see when they log in, such as associated CommCells. |
select C.name, C.net_hostname from APP_Client C, UMUsers U where dbo.isClientVisible(U.id,c.id, 0,0,0,0) = 1 and U.id = @sys_userid |
|
sys_username |
Name of the logged-in user. Like sys_userid, you can use this parameter to filter the data that report users see, based on their associations. |
select C.name, C.net_hostname from APP_Client C, UMUsers U where dbo.isClientVisible(U.id,c.id, 0,0,0,0) = 1 and U.login = @sys_username |
|
sys_locale |
Used to detect the locale of the logged-in user. Based on the locale, dates or other words can be automatically formatted in that region’s standard or language. |