ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 How to get user logged in order to filter SQL quer

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
roquesalde Posted - 11/10/2021 : 11:08:26
Hi!

I need to list all subscriptions for any user logged into RP, I could build a query to get that information but I don´t know how to get the user logged in order to filter the query and only show subscriptions for that particular user.

I tried using SUSER_SNAME() but I am getting the SQL user configured in the connection, and I need the RP user.

Any idea?

Thanks,
Roque
2   L A T E S T    R E P L I E S    (Newest First)
roquesalde Posted - 11/15/2021 : 19:23:19
Thank you very much!
admin Posted - 11/11/2021 : 20:04:48
Please try the Job, JobUser and AppUser tables:

http://www.reportportal.us/ReportPortal/help/index.aspx?page=architecture.htm

http://www.reportportal.us/ReportPortal/help/images/ERD/Scheduler.gif




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