top of page

For any support or more customized script, contact us -  binextlevel@gmail.com

Filter Dropdown in Widget

Here is script to add filter dropdown to a widget. We can filter to a particular item by selecting an item from the list.




Steps:


  1. Create a Line/Column/Bar/Area/Pie chart

  2. Add below script to the widget and update the variable 'dimension' with name of dimension in the format "[Table Name.Column Name]". Items in this field will be displayed as button. Add the same column in widget filter pane and select one item in it.

  3. Save the script and refresh widget.



widget.on('processresult', function(se, ev){	
	ev.result.chart.spacing = [30, 20, 77, 20 ]
});
                        
var dimension = '[Records.Region]'

widget.on("domready", function(w){
		
	var chart = w.chart[0][Object.keys(w.chart[0])[0]].hc
	
	let items = getItemList(w).values;	
	let itemlist = Array.from(items, x=>x[0].data)
	
	let widgetFilter = widget.metadata.panels[3].items.find(el => el.jaql.dim == dimension)
	
	var chartContainer = $('.highcharts-container', element)
	
	var dropdownHTML = `<select style="padding: 5px 10px; background:#FFFFFF; border: 1px solid #c0c1c2; margin:2px 5px;" name="select" id="select-${w.oid}"></select>`
	chartContainer.before(dropdownHTML)
	
	$.each(itemlist, function(index, value){
		$(`#select-${w.oid}`).append(`<option value=${value}>${value}</option>`)
	})	
	
	chartContainer.height(chartContainer.height() - 77);
	
	var selecteValue = itemlist[0] 
	
	console.log(widgetFilter)
	
	if(widgetFilter && widgetFilter.jaql.filter && widgetFilter.jaql.filter.members)
		selecteValue = widgetFilter.jaql.filter.members[0]
		
		
	document.getElementById(`select-${widget.oid}`).value = selecteValue
	var select = document.getElementById(`select-${widget.oid}`);

	select.addEventListener('change', (e) => {
		console.log(e)
	  		var selectedItem = e.target.value
			widgetFilter.jaql.filter.members[0] = selectedItem
			widget.refresh();

	});

});


function runHTTP(jaql) {
  // Use $internalHttp service if exists
  const $internalHttp = prism.$injector.has("base.factories.internalHttp") ?
  prism.$injector.get("base.factories.internalHttp") : null;
  // Ajax configurations
  const ajaxConfig = {
    url: "/api/datasources/" + encodeURIComponent(jaql.datasource.title) + "/jaql",
    method: "POST",
    data: JSON.stringify(jaql),
    contentType: "application/json",
    dataType: "json",
    async: false
  };
  // Use $internalHttp service for v8.0.1+
  // else use default ajax request
  const httpPromise = $internalHttp ? $internalHttp(ajaxConfig, true) : $.ajax(ajaxConfig);

  // Return response
  return httpPromise.responseJSON;
};

function getItemList(widget) {
  const query = {
    "datasource": widget.datasource.title,
    "metadata": [
      {
        "jaql": {
          "dim": dimension,
          "filter": {
						"explicit": false,
						"multiSelection": true,
						"all": true
					}
        }
      }
    ]
  };
  return runHTTP(query);
}




55 views0 comments

Recent Posts

See All
bottom of page