7 Replies Latest reply on Mar 25, 2020 11:22 PM by mortenbodaugaard.jrgensen

    PostgreSQL: count hidden worksheets on dashboard

    Robert Biese

      Dear,

       

      I am trying to count the number of worksheets in a workbook. The problem I have is: I can't count the worksheets which are used in a dashboard and thereby hidden.

       

      Tree_Tab_Proct_Project_Workbook_Sheettype_Views.PNG

      Each dashboard has several views, which are not shown at te 'view' section

       

      What am I missing?

       

      Schema.PNG

      The table VIEWS doesn't show the hidden views on the dashboard. By unhiding the views in the dashboard, they are visible in the VIEWS table. But in which table to find them when they are hidden?

       

      Thanks in advance.