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
 How to get user logged in order to filter SQL quer
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

roquesalde

Argentina
38 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

1635 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
38 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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page