cancel
Showing results for 
Search instead for 
Did you mean: 
Community_Admin
Community Team Member
Community Team Member

Question

I want to use the Date picker for filtering, however, the dates selected are not getting preserved by the date picker and might be confusing for the end users whether the date is selected or not.

Community_Admin_0-1634632200939.png

Answer

You can use the script to keep the selected values in the filter.

widget.on('ready',function(se,ev){

if (!Array.isArray(se.queryResult)) return;

var minMax = se.queryResult.reduce(function(acc, val){
if((!acc.min) || acc.min>val[0].Value){acc.min = val[0].Value}
if((!acc.max) || acc.max<val[0].Value){acc.max = val[0].Value}
return acc
} , {min:undefined,max:undefined})


formatted_dateFrom = moment(minMax.min).format('YYYY-MM-DD')
formatted_dateTo = moment(minMax.max).format('YYYY-MM-DD')

document.getElementById("data.filters[0].filterJaql.from").value=formatted_dateFrom
document.getElementById("data.filters[0].filterJaql.to").value=formatted_dateTo

document.getElementById("data.filters[0].filterJaql.from").setAttribute("style", "text-align:center");
document.getElementById("data.filters[0].filterJaql.to").setAttribute("style", "text-align:center");

})

This will pull the values for you.

Comments
kreycraft
Sisense Team Member
Sisense Team Member

I've tried this as both a widget and dashboard script and it hasn't worked yet.  I'm missing the connection between date filter and populating the Blox widget. 

 

kreycraft_0-1648585191302.png

 

kenterickson
8 - Cloud Apps
8 - Cloud Apps

I'm having the same issue as @kreycraft - script doesn't seem to help.

kenterickson
8 - Cloud Apps
8 - Cloud Apps

@Community_Admin The  queryResult property returns an object, not an array.  Therefore, line 3 exits this script with nothing happening.

Jijish
8 - Cloud Apps
8 - Cloud Apps

Facing similar issues. Any inputs on how to solve this issue will be greatly appreciated

Version history
Last update:
‎10-19-2021 01:31 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: