ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 User Filter Value and Shared SQL Filters on SQL

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
rgamezlertek Posted - 07/04/2016 : 13:02:57
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.
1   L A T E S T    R E P L I E S    (Newest First)
admin Posted - 07/04/2016 : 13:37:00
- 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.

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page