Intersoft Community - WebGrid Enterprise - Filter Grid

Filter Grid

leo.c — Thu, 02 Apr 2015 01:32:52 GMT

Hi John,

Glad that it worked for you. For your information, currently we only support lowercase "and" for Between filter type, so you must use lowercase "and" to make it work.

Best Regards,
Leo

Filter Grid

John.Bonin@dot.gov — Mon, 30 Mar 2015 12:50:52 GMT

Hi Leo,

Thanks for the response. I've got it working now, but here is the kicker....

If I use: fltr = New WebGridFilter("OOSDays", ColumnFilterType.Between, "1 and 5")

it works and the proper records are returned, but if I make a very minor change to:

fltr = New WebGridFilter("OOSDays", ColumnFilterType.Between, "1 AND 5")

(changed word from lower case and to upper case AND) No records are returned and the filter shown in
the FilterBar is 03/30/2015 and 03/30/2015.

Looks like a possible bug with the case of statements.

Filter Grid

leo.c — Mon, 30 Mar 2015 05:04:07 GMT

Hi John,

I have made a simple sample in order to reproduce your issue. Unfortunately I could not reproduce your issue. I could add between filter programatically.

I have attach a simple working sample as your reference. Please have it evaluated on your end by adding it to webgrid sample included in installation folder.

Best Regards,
Leo

Filter Grid

John.Bonin@dot.gov — Fri, 27 Mar 2015 15:02:41 GMT

Having a problem with the Between filter when set programatically.

My code is:

fltr = New WebGridFilter("OOSDays", ColumnFilterType,Between, "1 and 5")
WebGrid1.RootTable.FilterColumns.Add(fltr)

The OOSDays columns is set to be System.Single, when I run code no records are returned when 3 should be. If I look at the filter column in the grid I see "03/27/2015 and 03/27/2015". For some reason my filter text (1 and 5) got converted to today's date. If I manually add the filter in the grid than all works fine. I have used other filters programtically and they all work, its just the BETWEEN that doesn't.

Any ideas?

thanks

john