Filter fields with multiple values

rwjblue / pivot.js

Build Pivot Tables from CSV/JSON Data

http://rwjblue.github.com/pivot.js/

Other

783 stars 134 forks source link

Filter fields with multiple values #10

Closed sabas closed 11 years ago

sabas commented 11 years ago

When adding a filter,

select a value
add another filter
select again first filter, and select a different value.

In the table the filter is applied with the second value, but in the dropdown there are two occurrencies with the different values.

So this is a bug, but what about implementing the filter on multiple values of the same column? (as in excel) example column A has values: 1,2,3,4,5 Filter Fields on column A and values 2,3,4 (instead of a single value)

rwjblue commented 11 years ago

The behavior described is most definitely a bug. I will likely need to remove (or hide) any displayed filter fields from the filter field drop down list.

RE: Multiple Filter Values:

pivot.js itself can definitely filter based on multiple values (see here). I just couldn't decide on a good way to allow multiple selections in the UI. Looks like using select2 might work intuitively enough...

sabas commented 11 years ago

Nice, Multiselect behaviour is similar to TextExt

rwjblue commented 11 years ago

I hadn't seen TextExt before, but it looks like a perfect fit for this also.

sandeeppatel344 commented 10 years ago

filters : {"Animal" : /Lion|Ziraffe|Tiger/}

Worked For Me.... though Little Bit Up And Down