Jump to content
Changes to the Jaspersoft community edition download ×

how to know owner of report from jasperdatabase


titaporn.c

Recommended Posts

I have many users create a report on Jasper studio then public to jasper server, after that when we use that report or want to edit the report we don't know who can I contract with

I try to get from jasperdatabase but I can find only who edit the report on last 3 month  from  this sql 
select jr.id, jr.name, jr.label, jr.creation_date,ja.user_id, ju.username
   From jiresource jr, jiaccessevent ja, jiuser ju,jiresourcefolder jf
where jr.id = ja.resource_id
--and ja.updating = false
and jr.parent_folder = jf.id
and ja.user_id = ju.id
and jf."name" like('%Inventory_SKU_List%')
order by jr.creation_date asc

 

Do you have another way to get real person who create(public) the report to the server 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...