⚠ In case you've missed it we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This forum is read-only and soon will be archived. ⚠


Flexigrid Search All for Date, Datetime and Timestamp not working

flexigrid search all Date Datetime Timestamp

  • Please log in to reply
No replies to this topic

#1 clustersblue

clustersblue

    Advanced Member

  • Members
  • PipPipPip
  • 40 posts

Posted 28 May 2018 - 09:46 AM

Hi GCer,

 

In my GC page using Flexigrid theme I noticed that when Search All on a Date type column it doesn't return any data.  The same with datetime and timestamp data types.  Though working if I select the column individually.

 

After further investigation I noticed in the Grocery_CRUD.php library line 674 there is this line

!in_array($field_types[$column->field_name]->type, array('date','datetime', 'timestamp'))

I don't know what's the purpose of excluding those data types from Search All query in GC.  Removing the 'date' solves this issue.  As to the effect of it that is still under test.

 

Does anyone knows the purpose of having that line in the query?  It seems this is not under Flexigrid but in GC.

 

 

Thanks

Clustersblue







Also tagged with one or more of these keywords: flexigrid, search all, Date, Datetime, Timestamp

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users