Big news! The community will be moving to a new platform April 21. Read more.
Big news! The community will be moving to a new platform April 21. Read more.
Absent Member.. Absent Member..
Absent Member..
939 views

Are QC 10 dashboard excel report queries stored in the db?

Are QC 10 dashboard excel report queries stored in the db?

 

If so- what table(s)?

 

Thanks!

tm1
0 Likes
1 Reply
Admiral Admiral
Admiral

The graphs and reports data is located in ANALYSIS_ITEMS Table.

 

The filed AI_IS_PUBLIC contains the information (Y/N) if the entity is public.

The name is stored in AI_NAME.

AI_ID

The record ID.

AI_IS_PUBLICAI_TYPE defines if it is Report, graph etc.

 

DASHBOARD_PAGE_ITEMS, DASHBOARD_PAGES, DASHBOARD_FOLDERS. --folder,page tables

Each table contains filed called  DP_IS_PUBLIC. The values assigned are Y if public or N for private

 

Regards,

Venkat

Venkat
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.