⚠ 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

filtering by column



sneezyyzeens
  • profile picture
  • Member

Posted 12 February 2012 - 22:08 PM

Is it possible to use groceryCrud to create individual column filters?

If not, is there an easy way to integrate datatables plugins with groceryCrud?

I've been running in circles for a week now, so I'm starting back at the beginning with groceryCrud.

Grocery Crud works great, except it doesn't have the individual column filters (that I can find?)

So I tried using datatables directly (via the Ignited Datatables library), and I really, REALLY liked the columnFilitering with this plugin: http://www.datatables.net/extras/thirdparty/ColumnFilterWidgets/DataTables/extras/ColumnFilterWidgets/

But it doesn't work with server-side data. :(

So then I tried the other filtering plugin: http://jquery-datatables-column-filter.googlecode.com/svn/trunk/default.html and got it working, though it's not as robust as the other one (which allows filtering on more than one value). Plus I'd still need to do all of the Create/Update/Delete pages, which Grocery does so nicely.

So before I do that work, I figured I'd check to see if I was missing a way to do the filtering with GroceryCrud.

web-johnny
  • profile picture
  • Administrator
  • 1,166 posts

Posted 16 February 2012 - 19:03 PM

Sorry for the delayed answer. Actually I worked with this multiple column filtering and it works fine. I really like the multiple column grid and I think I have to included to grocery CRUD. For now it is NOT available to grocery CRUD but I will try to have a feature like this in the future.

sneezyyzeens
  • profile picture
  • Member

Posted 04 March 2012 - 16:42 PM

Just as an update in case anyone else wanted to do this (use groceryCrud for CRUD actions, but use a different list page) I did a minor hack to the grocery_crud.php library and changed the getListUrl() function from

 protected function getListUrl()
{
return $this->state_url('');
}


to

 protected function getListUrl()
{
return $this->state_url('../');
}


so mysite.com/listing --> list page
mysite.com/listing/crud/edit --> edit page
mysite.com/listing/crud/add --> add page
etc.

mysite.com/listing/crud still gives the grocery_crud formated listing, but my site's navigation never points to it.

I ended up changing some of the grocery_crud templates as well, but I think those were all just cometic changes.

Raboo
  • profile picture
  • Member

Posted 11 September 2012 - 08:00 AM

Hi,

I was thinking of posting a feature request. But then i found this old thread.. I would also like to see this feature. A way to filter each column.

Is it simple to add this manually?

francoross
  • profile picture
  • Member

Posted 06 March 2015 - 07:21 AM

Can you share a demo file with sql file, please?

I would like integrate individual column filters for flexigrid