Forum Discussion

benson_lv's avatar
benson_lv
Cloud Apps
10-18-2023
Solved

How to synchronize 2 filters

Hi Guys, The requirement is that i have a dashboard need to access 2 different datasource. The 1st widget(table) is extract data from datasource 1, and there is a filter1: serial number The 2nd wi...
chriskerrison21's avatar
chriskerrison21
Cloud Apps
11-28-2023

Hello, we are trying to achieve the same thing - linking filters together. But, these filters are also linked to different data sources to the parent filter.

I've added code to the filterschanged event, I'm correctly setting the "child" filters based on the parent filter, and then calling the dashboard refresh.  The filters get updated correctly, the dashboard appears to refresh, but any widget attached to the "child" filters are not getting updated. If I hit ctrl+f5, they do update.

Any assistance would be great as we have a particularly tricky customer wanting this resolved

  • ILLIA's avatar
    ILLIA
    Sisense Employee
    11-29-2023

    Hello!

    Could you please advice if you can share your current script in order to check it? 

    Best regards,

    • chriskerrison21's avatar
      chriskerrison21
      Cloud Apps
      11-29-2023

      sure, here is the script. We have 5 filters, each pointing to a different data source. the top level filter is enabled, the other 4 are locked, but these should be automatically set based on the values selected in the top filter. 

       

      dashboard.on('filterschanged', function(se, ev)
      {
      if (ev != null && ev.items.length > 0 && ev.items[0].jaql.table == "AT Structure") -- this is the top level / enabled filter
      {
      --are all items selected? 
      if (ev.items[0].jaql.filter.members == null)
      {
      se.filters.$$items[1].levels[1].filter.all = true;
      se.filters.$$items[1].levels[1].filter.explicit = false;
       
      se.filters.$$items[2].levels[1].filter.all = true;
      se.filters.$$items[2].levels[1].filter.explicit = false;
       
      se.filters.$$items[3].jaql.filter.all = true;
      se.filters.$$items[3].jaql.filter.explicit = false;
       
      se.filters.$$items[4].levels[1].filter.explicit = false;
      se.filters.$$items[4].levels[1].filter.all = true;
       
      se.$dashboard.refresh();
       
      }
      else
      {
      --Set the "child" filters applicable to the Manager(s) selected in filter 1
      let managers = [];
      for (let i = 0; i < ev.items[0].jaql.filter.members.length; i++)
      {
      if (ev.items[0].jaql.filter.members[i] == 'Dean Thomas')
      {
      managers.push('Portfolio 1');
      }
       
      if (ev.items[0].jaql.filter.members[i] == 'Matt Davis')
      {
      managers.push('Portfolio 2');
      }
       
      if (ev.items[0].jaql.filter.members[i] == 'Rachael Hawkins')
      {
      managers.push('Portfolio 3');
      }
       
      if (ev.items[0].jaql.filter.members[i] == 'Rebecca Dunning')
      {
      managers.push('Portfolio 4');
      }
      }
       
      se.filters.$$items[1].levels[1].filter.all = false;
      se.filters.$$items[2].levels[1].filter.all = false;
      se.filters.$$items[3].jaql.filter.all = false;
      se.filters.$$items[4].levels[1].filter.all = false;
       
      se.filters.$$items[1].levels[1].filter.explicit = true;
      se.filters.$$items[2].levels[1].filter.explicit = true;
      se.filters.$$items[3].jaql.filter.explicit = true;
      se.filters.$$items[4].levels[1].filter.explicit = true;
       
      se.filters.$$items[1].levels[1].filter.members = managers;
      se.filters.$$items[2].levels[1].filter.members = managers;
      se.filters.$$items[3].jaql.filter.members  = managers;
      se.filters.$$items[4].levels[1].filter.members = managers;
      se.$dashboard.refresh();
      }
      }