Hide Content panels with empty queries

JoshK131

Hello,

I have a visual perspective set up with multiple content panels displaying queries.

To clear clutter, I would like to completely hide the queries which do not display any records.

I've been trying out render scripts on the content panels but it is not working.
The error I am getting is: Exception running render script for panel BAS_FRAME_main_HTMA_Request_Panel2 TypeError: Cannot read properties of undefined (reading 'wrapperId')

var grid = $("#" + parser.m_widgetInfo.wrapperId).find(".k-grid").data("kendoGrid");
console.log("grid found");
grid.bind("dataBound", expand);
console.log("script end");

function expand(e) {

console.log("enter function");

console.log(grid.dataSource.total());
if (grid.dataSource.total() == 0 ){
    //Hide grid

console.log("total empty");
      $(grid).hide();
    }
    else{
      //Show grid
console.log("total visible");
      $(grid).show();
    }
}

How shall I solve this problem?

joben

This is how we do it:

Instead of using "Display results of query", use "Display results of process".

Then make your process like this:

If COUNT YourBoName >0 Then
DISPLAY 'Name of your query'

Or you could use EXISTS :

If EXISTS YourBoName WHERE (YourBoName.Name CONTAINS 'John') Then
DISPLAY 'Name of your query'

If nothing is found, the content panel will be empty.

I think this method is awesome and we use it alot. It makes the start page really clean, and the important stuff will always be visible.

JoshK131

Brilliant,

Nice solution, no need for javascript.

Thank you very much