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?
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
I don't have background filters set on this current filter, what is happening is the se.filters.update(datefilter, filterOptions) command is altering all my other filters, and any with backround filters set are gettin gmessed up. I just need to code to touch filter "Date" and thats it
Since we added below line of code, it should filter to only 'Date' filter.
filter = se.filters.$$items.find(el=>el.jaql.title == 'Date')Are you using same script as above? If possible, can you share the script you are using, so that I can try to replicate the issue.
-Hari
Since 'm using older data in my DEV environment the latest date i have is from June so i'm hard coding it for now
dashboard.on('initialized', function (se, ev) {
currentYear = '06/01/2022'
datefilter = se.filters.$$items.find(el=>el.jaql.title == 'As Of Month')
datefilter.jaql.filter = {
"explicit": true,
"multiSelection": false,
"members": [currentYear]
}
var filterOptions = {
save: true,
refresh: true,
}
se.filters.update(datefilter, filterOptions)
});
