Reassigning a scheduled report

Jeanne

I’m not sure if this works, but you can try it in test.

·         Find the id for the report request linked to the schedule (SELECT request_id FROM gooesoft_report_schedule WHERE name = ‘the name of your schedule’)

·         Change the user id for the report request (UPDATE gooesoft_request SET user_id = ‘new user’ WHERE id = the id you find in the step above)

Fernando Margueirat
Senior Business Analyst
The National Ballet of Canada
470 Queens Quay West
Toronto, Ontario
M5V 3K4
P: 416 345 9686 x453
F: 416 345 8323

http://national.ballet.ca

A user needs to be able to change the schedule of a report which was originally scheduled by another user. Since users can only see reports they themselves scheduled (unless they’re in the admin group), this doesn’t appear to be possible. So the question becomes is there a way to reassign a scheduled report to someone else, or is our only option to delete the schedule and recreate it?

I can always change it as System Admin, but I’d love for this sort of thing to be self-service.

Thanks!

Jeanne

Jeanne DeVore | Technology Manager
Chicago Shakespeare Theater

312. 667.4943 direct line  | 312.403.0314 mobile | www.chicagoshakes.com | facebook | twitter
800 East Grand Avenue on Navy Pier | Chicago, Illinois 60611

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Jeanne

I’m not sure if this works, but you can try it in test.

·         Find the id for the report request linked to the schedule (SELECT request_id FROM gooesoft_report_schedule WHERE name = ‘the name of your schedule’)

·         Change the user id for the report request (UPDATE gooesoft_request SET user_id = ‘new user’ WHERE id = the id you find in the step above)

Fernando Margueirat
Senior Business Analyst
The National Ballet of Canada
470 Queens Quay West
Toronto, Ontario
M5V 3K4
P: 416 345 9686 x453
F: 416 345 8323

http://national.ballet.ca

A user needs to be able to change the schedule of a report which was originally scheduled by another user. Since users can only see reports they themselves scheduled (unless they’re in the admin group), this doesn’t appear to be possible. So the question becomes is there a way to reassign a scheduled report to someone else, or is our only option to delete the schedule and recreate it?

I can always change it as System Admin, but I’d love for this sort of thing to be self-service.

Thanks!

Jeanne

Jeanne DeVore | Technology Manager
Chicago Shakespeare Theater

312. 667.4943 direct line  | 312.403.0314 mobile | www.chicagoshakes.com | facebook | twitter
800 East Grand Avenue on Navy Pier | Chicago, Illinois 60611

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!