Find draft reports in client organizations

Tara Wilson shared this question 2 years 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.

Comments (3)

photo
1

Hi Tara,


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


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


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


Regards,

Nathan

photo
1

Hi Nathan,


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


Best,

Tara

photo
1

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