Forum Discussion
8 Replies
Replies have been turned off for this discussion
- harikm007Data Warehouse
Hi jplefka ,
One alternative is to write a similar script in 'initialized' event of dashboard.
For example:
dashboard.on('initialized', function (se, ev) { currentYear = new Date().getFullYear().toString() datefilter = se.filters.$$items.find(el=>el.jaql.title == 'Date') datefilter.jaql.filter = { "explicit": true, "multiSelection": true, "members": [ currentYear ] } var filterOptions = { save: true, refresh: true, } se.filters.update(datefilter, filterOptions) });
-Hari
- jplefkaData Storage
Thanks, this works great for changing the date filter, however it keeps clearing out preset background and locked filters that I have, is there a way I can stop that from happening?
- harikm007Data Warehouse
jplefka If you have background filter set, try below script:
dashboard.on('initialized', function (se, ev) { currentYear = new Date().getFullYear().toString() filter = se.filters.$$items.find(el=>el.jaql.title == 'Date') backgroundfilter = filter.jaql.filter.filter defaultValue = 'West' filter.jaql.filter = { "explicit": true, "multiSelection": true, "filter":backgroundfilter, "members": [ currentYear ] } var filterOptions = { save: true, refresh: true, } se.filters.update(filter, filterOptions) });
-Hari