bindingcomplete, addfilter, filtervalue

[redjaneMember]

Hi, I just want to set the filtervalue to, let say, “CE” when loading the grid.
First I thought, why not set

filtervalue: 'CE' 

when setting up the columns. But that doesnt work.

I had to add the following code

$("#jqxgrid").bind("bindingcomplete", function (event) {
	var filtergroup = new $.jqx.filter();
	var filter_or_operator = 1;
	var filtervalue = 'CE';
	var filtercondition = 'equal';
	var filter1 = filtergroup.createfilter('stringfilter', filtervalue, filtercondition);
	filtergroup.addfilter(filter_or_operator, filter1);
	$("#jqxgrid").jqxGrid('addfilter', 'code', filtergroup);
	$("#jqxgrid").jqxGrid('applyfilters');
});

Can it be done easier by just setting the filtervalue on ‘CE’ in the columns?
It is a ‘list’ filtertype.

Second question:
Can we remove or rename the ‘Please chose’ option in a list-filtertype?

thank you.

[Peter StoevKeymaster]

The Grid’s Filtering sample adds a filter to the first column. You can use the same pattern.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[redjaneMember]

Thx Peter, so its like I wrote, can not be done by just adding ;

{ text: 'pModel', dataField: 'model_naam', width: '10%',filterable: false, filtervalue: "test" }

(adding: filtervalue: “test” )
I couldnt find a sollution for my second question :

Can we remove or rename the ‘Please chose’ option in a list-filtertype?

[Peter StoevKeymaster]

Hi redjane,

“Please Choose” is specified in the localization object used by jqxGrid. You can set a new localization object in order to remove it.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[redjaneMember]

All works great… but
when setting a filter on grid load, the list-filtertype is set to “Please choose:” not the filtervalue. Something I forgot?

Peter, I must say: GREAT support ! Even if we have stupid little questions

[pankyParticipant]

Hi

Can we remove or rename the ‘Please chose’ option in a list-filtertype?

-Panky

[Peter StoevKeymaster]

Hi panky,

If you want to rename, localize strings, then you can look at: http://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-localization.htm

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[pankyParticipant]

Awesome Thanks Peter !!

-Panky

[Author]

Posts