Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 User Filter Value and Shared SQL Filters on SQL		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rgamezlertek

1 Posts
Posted - 07/04/2016 :  13:02:57  Show Profile  Reply with Quote
I can't find any examples of using both of those modules combined on SQL Reports. Does anyone knows how to do this?

I have a shared filter with clients and I want to use user filter values for different roles.

Also can i use user filter values directly on the sql of the sql reports?

I want to do this to have global reports for all the users but with different information on filters and results.
Edited by - rgamezlertek on 07/04/2016 13:06:14

admin

1637 Posts
Posted - 07/04/2016 :  13:37:00  Show Profile  Reply with Quote
- The Shared Filter can be used by multiple reports. For example, it can list 50 US states.
- User Filter Value can let you select the default value in the filter. For example, it can select "Florida" for a role or a user.

Your filter can use security based on user info. Following security tokens can be used:
::UserId - ReportPortal User ID
::UserName - ReportPortal User Name
::NtUserId - Windows User ID
::Email - Email

Role and UserRole tables in ReportTable database have Role information for the user.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page