Skip to Content
avatar image
Former Member

Script function isResultSetEmpty() doesn't work properly in 1.6

Hello Experts,

I'm using the script function isResultSetEmpty() to check if there is any data in my data source but I don't get the right result.

Example:

I have 2 drop downs and 1 crosstab in my application. I have assigned data source DS_1 to the crosstab. DS_1 is a query with 2 input (optional variables - I set these variables with the values selected in the drop downs. I want to hide the table when the source is initial. When I start the application there is no data so crosstab is invisible, when I change the selection in one of the drop downs data source is not initial but table is still invisible because the function isResultSetEmpty() returns "true". My check is in the "On result set change event" of the data source.

if (DS_1.isResultSetEmpty() == true) {

CROSSTAB_1.setVisible(false);}

else { CROSSTAB_1.setVisible(true); }

If I remove this code the table is visible - first time it's initial and second time, when I select the same value like in the example above - table with the data is displayed.

Do you have any ideas how if there is any other way to check the result set? Or why the script function doesn't work?

Aylin

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Mar 30, 2016 at 12:21 PM

    Aylin - Karol makes some good suggestions in this thread:

    Could you review his responses with your application?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Tammy Powlas

      Thank you very much for your help Tammy!

      Unfortunately I'm not able to try with SP1 - I'm working on customer site. When the customer decide to upgrade Design Studio I'll check if the check with the function isResultSetEmpty() works.