<< Click to Display Table of Contents >> Current:  Resource Deployment > Server and Desktop Resource Upload and Download > Add User Row Filtering and Column Filtering (Desktop Version)  Row Filtering

9.1 and later versions support setting the parameters in the row filter in Desktop. When Desktop connects to the server, the following parameters will be displayed in the row filter of the data set: {_USER_},?{_GROUPS_},?{_ROLES_},?{_USER_ALIAS_},?{_USER_custom attributes_}. If Desktop is not connected to the server, the parameters will not be displayed: {_USER_},?{_GROUPS_},?{_ROLES_},?{_USER_ALIAS_},?{_USER_custom attributes_}.

 

For example:

1. Desktop connects to the server, the connection user is user1:

 

2. Set row filtering for the data set in Desktop:

Create a new embedded data set: embedQuery1, the data is as follows:

The filter conditions are as follows:

3. The execution results after setting the filter conditions are as follows:

4. Execution on the Server side:

Create a new dashboard: db1, bind the data set: embedQuery1, and upload db1 to the Server side. On the Server side, log in with user user1, enter the view dashboard, and open the dashboard db1. The results are as follows: