Loading...

System Parameters for Build Your Own Reports

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.

 

 

 

Last modified: 3/12/2018 7:23:10 PM