Retrieve all Reports created using AdHoc View based on Role

0

Hi community,

I'm trying SQL Query to fetch all the "AdHoc Reports" created from AdHoc views depending on the user ROLE.

What DB tables I've to refer to write an SQL Query to fetch  all the "AdHoc" reports created filtered by User Role.

Thanks & Regards

 

 

Balraj's picture
236
Joined: Jan 29 2015 - 7:25pm
Last seen: 2 years 2 months ago

1 Answer:

0

You can refer below tables:

  • jireportunit
  • jiresource
  • jiuserrole
  • jiuser
  • jirole
  • jitenant
  • jiobjectpermission
Siddharth Kothari's picture
Joined: Jan 23 2015 - 9:38am
Last seen: 2 years 2 months ago
Feedback
randomness