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
Hello,
I noticed that the filter bar does not always work for dates as I would expect it to. If the date's time of day compoment is 12:00 am and so the date is something like '10/15/2010 12:00:00 am', then if I enter a short date like 10/15/2010, the filter will return proper results. If however the time of day is something other than 12:00 am, like 1:30 pm, then the date will not be returned by the filter.
The only way I can get the date to be found by the filer is if I enter the excact value '10/15/2010 1:30 pm', but that's not very intuitive for the users
Is there a way I cand get aroud this problem?
Hi Dasha,
Yes, that is a default behavior of our filtered column. As you might noticed, our behavior is basically based on what SQL is capable. If we do not set the time, by default, it will return us a value of 12:00:00 AM or 00:00:00 AM. So, you will need to specify the time as well to get the particular value. In other hand, perhaps you can change the filter type into Between, for example, 10/15/2010 and 10/16/2010. Those will give us all the data for one day of 10/15/2010.
Although, you can create your own validation on your back end using initializePostBack and override the filter type, however, it will be so complicated since we do not support this kind of scenario.
I hope it helps. Thank you and have a nice day.
Best Regards,
Andi Santoso
Andi, thank you for the explanation, I will pass it on to our team.
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
Creating your account...