Datetimepicker column search not filtering data

QuestionsDatetimepicker column search not filtering data
Sunil asked 4 years ago

Hi,
The datetimepicker integration with the latest build does filter date with column filtering.
I checked with the previous version of grid its the same issue there.

3 Answers
Abu Ghufran answered 3 years ago

I am unable to regenerate this issue.
Demo: http://www.phpgrid.org/demo/demos/integrations/datetimepicker.php

Steps: i type date 6/10/2007 in auto filter of datetime field.
Please tell exact steps to get this issue.

Sunil answered 3 years ago

It works if date is keyed in the search field, I typed 06/10/2007 05:00:00, though its the entry that is there in the grid it says "No records to view"

Abu Ghufran answered 3 years ago

The issue was with the timezone convertion. It was displaying GMT+5 and saved in db was gmt+0.

I've changed to $col["dbname"] so that it can be used in WHERE clause instead of plain field.

http://www.phpgrid.org/demo/demos/integrations/datetimepicker.php
http://www.phpgrid.org/demo/demos/integrations/datetimepicker.phps

Your Answer

4 + 19 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!