Retrieve all Reports created using AdHoc View based on Role


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
Joined: Jan 29 2015 - 7:25pm
Last seen: 2 years 2 months ago

1 Answer:


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