Add advanced filtering options

blmage / mage-enhanced-admin-grids

[ARCHIVED] Enhanced Admin Grids extension for Magento 1. WIP version available for testing.

248 stars 115 forks source link

Add advanced filtering options #45

Open peterjaap opened 11 years ago

peterjaap commented 11 years ago

I would like to filter on empty and negative values. Let's say I have a column for EAN's, I would like to be able to filter on '' in the EAN filter field, thus giving me all products that do not have an EAN set.

What also would be cool is to be able to filter out values (negative searching). Maybe add a '-' (minus) operator to be able to filter out EAN's that begin with 123 by searching for -123% or something.

Maybe even regex searching?

mage-eag commented 11 years ago

This is definitely a good idea, that in fact could be a new customization option for the text columns, called eg "Filter Type", and which would let the choice between :

default filter (equal or like with surrounding % or not),
negative filter (not equal or not like with surrounding % or not),
with/without values filter,
regex-based filter (still have to check older Magento versions for this one, but I guess it should anyway be achievable)

Don't hesitate if you have other filter type ideas ! :)

mage-eag commented 10 years ago

Available for testing in the 1.0.0-wip branch.

Also thinking to add a new option, to let the filter mode and negative flag be determined from the input.

peterjaap commented 10 years ago

Nice! Will check out asap :) :+1:

peterjaap commented 10 years ago

Seems to work pretty well! It's a bit of shame that 'Negative filter' can't be triggered by inputting something in the filter field, such as [!] as a prefix.

So; p(.*)jaap will return 'peterjaap' when set as regex filter, but [!]p(.*)jaap wil return all rows that don't have anything with 'peterjaap' or 'pooooojaap' in it.

mage-eag commented 10 years ago

Shortcuts are now available for both the filter modes and the negative filter, thanks for your feedback !

paales commented 9 years ago

@mage-eag Have you added documentation somewhere how this works? Also, maybe an additional feature request, is it maybe possible to search for multiple values? Maybe with a pipe | character or something?

advanced filtering possibilities for text, options and country columns (except for the original grid columns, as for the rest)

Is it maybe possible to implement these filteroptions for the original grid columns as well? To be able to search on the SKU with a wildcard would be a nice feature.