MS Excel like filters (with checkboxes) in WebDataGrid & ability to remove some items from filter drop down list

Hi Taz,

Will be a useful feature to have.

Any update on having Excel Checkbox filtering option in any of your web grids?

Please advise..

regards

surya

Hi surya,

In version 12.1, a version of this was shipped as CTP.

http://samples.infragistics.com/aspnet/Samples/WebDataGrid/Organization/ExcelStyleFiltering/Default.aspx?cn=data-grid&sid=28d09818-7853-46fb-ba0a-a930e003aa83

It would be great if you let us know what you think so far.

regards,
David Young 

Thanks a ton David.

regards

surya

Taz,

did you get the solution for moving some options from filtering dropdownlist?

thanks.

Hi tony,

You can remove options from the filtering drop down list (filter type of row) by simply handling the showing or shown client event and taking out the LI with the option you do not want to show.

regards,
David Young 

Hi David,

Thanks for your reply. Below is my codes. it really works for removing options from the drop down list, but, unfortunately, the checkboxes before each option are not avalible to click.
Please help check what's the problem of the codes. thanks a lot.

function Filtering_FilterDropdownDisplaying(sender, eventArgs) {

var tc = sender.get_targetContainer();

if(tc.hasChildNodes()) {

if (sender.get_targetContainer().children[1].innerText.indexOf('<a') > -1) {

var html = $(sender.get_targetContainer().children[1].innerHTML);

$.each(html.find('li'), function(index, ctrl) {

if ($(ctrl).attr('val').indexOf('<a'

) > -1) {

$(ctrl).remove();

}

})

sender.get_targetContainer().children[1].innerHTML = '<UL style="PADDING-BOTTOM: 0pt; MARGIN: 0pt; PADDING-LEFT: 0pt; PADDING-RIGHT: 0pt; PADDING-TOP: 0pt" key="Description">' + html.html() + '</UL>';

}

}

}

Hi David,

did you get the cause of my problem? thanks.

Hi,
I have not actually tried to debug it.  You should contact developer support for that.  however, just looking at it, I see you are using jquery to completely overwrite the UL.  The ul has the events attached to it.  So they are gone when you do it this way.  Why is it not sufficient to just called $(li).remove()?  The option will be gone.  There should be no need to build up the inner html and reapply it.

regards,
David Young