How to pass url parameter value into string filter input in Google visualization

Question

Hi i am stuck on pass URL parameter values into string filter input in Google visualization.i want to pass url parameter when report is ready instead of user type on it and filter data from table.

eg :http//mypage?id=1234

var fteFilter = new google.visualization.ControlWrapper({ 
    'controlType': 'StringFilter', 
    'containerId': 'control_div8', 
    'options': {           
      'filterColumnLabel': 'FTE Id' ,
      'matchType':'any',
      'ui': { 
          'labelStacking': 'vertical',
          'label': 'FTE Id :'
        }
    } 

  });

I'm not sure I understand your question. Are you trying to use the query string parameter to set your filter's starting value, or use your filter's value as part of a url? — nbering
– nbering, Commented Jan 21, 2015 at 20:20
I don't use any query string parameters.i just want to set URL parameter value as filter's default value when report is loading. — gihan-maduranga
– gihan-maduranga, Commented Jan 22, 2015 at 11:31

dtelaroli · Accepted Answer · 2015-03-04 12:07:41Z

To get the query parameter use the code (or other that you prefer):

function getQueryVariable(variable) {
       var query = window.location.search.substring(1);
       var vars = query.split("&");
       for (var i=0;i<vars.length;i++) {
               var pair = vars[i].split("=");
               if(pair[0] == variable){return pair[1];}
       }
       return(false);
}

https://css-tricks.com/snippets/javascript/get-url-variables/

Add to your filter the state value.

var id = getQueryVariable('id'));

var fteFilter = new google.visualization.ControlWrapper({ 
    'controlType': 'StringFilter', 
    'containerId': 'control_fteFilter', 

    'options': {           
      'filterColumnLabel': 'FTE Id' ,          
      'matchType':'any',
      'ui': {     
          'labelStacking': 'vertical',
          'label': 'FTE Id :'    
        }
    },
    state: {
        value: id
    }    
  });

Use selectedValues array to CategoryFilter.

state: {
    selectedValues: [id]
}

Collectives™ on Stack Overflow

How to pass url parameter value into string filter input in Google visualization

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related