Find draft reports in client organizations

Tara Wilson (new) shared this question ago

Answered

Is there a way to determine where draft reports in client orgs that are tied to a view live? For instance when I click the view info I see there are draft reports but don't know where they live or who created them. How can I find this information? I see the reports tab on the summary but it does not show draft report information.

The same question

Replies (3)

Nathan Schroeder ●

Hi Tara,

I was able to accomplish this by querying the configuration database:

SELECT * FROM 73yellowfin20170420.reportheader
WHERE ReportStatusCode = 'DRAFT'
and ViewId=59543

The appropriate ViewId can be found in your "reportview" table. Please let me know if this works for you!

Regards,

Nathan

Reply URL

Tara Wilson (old) ●

Hi Nathan,

Thanks so much! I just gave it a quick whirl and it appear to get me what I need.

Best,

Tara

Reply URL

Nathan Schroeder ●

Hi Tara,

Glad to hear it! I am going to set this to closed, but if this does not do what you want, or if you have any other questions, just reply and the case will be re-opened!

Regards,

Nathan

Reply URL