iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
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
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
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.
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.
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname