search

bogdan / datagrid

Gem to create tables grids with sortable columns and filters
MIT License
1.02k stars 116 forks source link

Filter is not working #221

Closed smitakiran25 closed 7 years ago

smitakiran25 commented 7 years ago

When i select the year of dob filtered data is not displaying please tell me what mistake i am doing hear I have added my code in https://github.com/smitakiran25/school_app

bogdan commented 7 years ago

On this line:

https://github.com/smitakiran25/school_app/blob/master/app/controllers/student_lists_controller.rb#L4

Change :student_lists to :student_lists_grid.

smitakiran25 commented 7 years ago

after changing :student_lists to :student_lists_grid. syntax error is coming screenshot from 2017-05-03 15-27-06

bogdan commented 7 years ago

The code in your filter is written for PostgreSQL not for SQLite.... I am not an SQLite expert and can't advice anything as it is far beyond the datagrid. You may ask on http://stackoverflow.com how to rewrite the code for SQLite.

kirantpatil commented 7 years ago

@bogdan, thanks for the suggestion. We were not aware that the code is specific to Postgresql.

smitakiran25 commented 7 years ago

Thank you sir its working fine in Postgresql