Home Home
  login

Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Enable all reports on all projects

reporting

Hi all,

is it possible to enable in one step (maybe a SQL script) all reports on all projects? I would really appreciate such a solution, as it would save me lots of time on walking manually through all projects.

Thx in advance Daniel
dawolf
· 1 		dawolf
Tuesday, February 7, 2012, 10:53:41 AM
Replies (1)
helpful
0
not helpful
ANSWER

Sure, configure 1 project only and then copy it using SQL:

insert into geminireportsvisibility(reportid,reporttype, projectid, visibility, visibilitymembertype) select reportid,reporttype, p.projectid, visibility, visibilitymembertype from geminireportsvisibility r, gemini_projects p where r.projectid=your configured project id
Mark Wing
· 9108 		Mark Wing
Tuesday, February 7, 2012, 11:47:25 AM