Intersoft Community - WebGrid Enterprise - "Equals To" Filter doesn't working fine for "date" column

"Equals To" Filter doesn't working fine for "date" column

bernard — Thu, 27 Dec 2012 23:37:43 GMT

Hi Aswini,

I think this problem might happen because it's default behavior from MSSQL and Access database datetime data type. Actually, our filter will put the parameter inside filter column to server side then it will re-query the data using SQL statement (in this case using "equals to"). We also found out that this matter happen in MSSQL and Access database.

I also tried to convert the data type from datetime to date when selecting. but this method won't work for filtering. Maybe if you want, I will made this as feature request so our developer team will look further for this matter and if possible they will made a workaround regarding this problematic behavior.

Look forward to hear any feedback from you so I can help you further.

Regards,
Bernard

"Equals To" Filter doesn't working fine for "date" column

Aswini — Thu, 27 Dec 2012 04:45:19 GMT

hi Bernard,

i have tried but "Equals To" filter is working fine only for the date those have time part "12:00:00 Am",

http://live.intersoftpt.com/Default.aspx?url=cs/WebGrid/AutomaticFilterSuggestion.aspx

Go through the above link they have used the date those have time part "12:00:00 AM", so that all filter will work fine , but if we will change the time part as "01:35:24 Am" then it won't work.

Thanks with Regards

Aswini Maharana

"Equals To" Filter doesn't working fine for "date" column

bernard — Thu, 27 Dec 2012 03:07:57 GMT

Hi Aswini,

I tried to replicate your issue in our local end using WebGrid with DateTime data inside it. However, when I filter the data using Date only, it only shows the data which have the same date (I don't have to put the time). I also attach my sample here. Could you please look at my sample and tell me if there's any misconfiguration in my sample. Look forward to hear any feedback from you so I can help you further.

Regards,
Bernard

"Equals To" Filter doesn't working fine for "date" column

Aswini — Thu, 27 Dec 2012 02:09:21 GMT

For a "date" column if user want to filter it through "equals to" filter, then it requires the time part too, but my requirement is ”User can filter it only with date rather than using time”, so can you please help me here, how to override the filter type by using InitializePostBack, because if user will give only date rather then time part then it is only showing the date which have time 12:00:00 AM.