Report Portal
Report Portal
Home | Profile | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 How to get user logged in order to filter SQL quer
 New Topic  Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

roquesalde

Argentina
36 Posts

Posted - 11/10/2021 :  11:08:26  Show Profile  Click to see roquesalde's MSN Messenger address  Reply with Quote
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

Edited by - roquesalde on 11/10/2021 11:09:05

admin

1626 Posts

Posted - 11/11/2021 :  20:04:48  Show Profile  Reply with Quote
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



Go to Top of Page

roquesalde

Argentina
36 Posts

Posted - 11/15/2021 :  19:23:19  Show Profile  Click to see roquesalde's MSN Messenger address  Reply with Quote
Thank you very much!
Go to Top of Page
   Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Report Portal © RP Go To Top Of Page