⚠ 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 is an archived forum. ⚠

  •     

profile picture

Flexigrid Search All for Date, Datetime and Timestamp not working

Started by , 28 May 2018 - 09:46 AM


clustersblue
  • profile picture
  • Member

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