Filtering for multiple options in a field with a single value
Filtering for multiple options in a field with a single value
I've done some regex before that has worked nicely but having a problem with that because I don't think it applies. I think what I need is an OR filter...in english: filter this row to display if column 23 has a 3 or a 12 in it. I built a regex but it would only apply if behind the scenes you were concatenating all the unique values in that field. Some forum discussions let me to believe that table.fnFilter('3 12", 23) would work, but that is an AND clause in essence...if this column contains a "3" and contains a "12"...but I need OR's across rows.
Is this making sense? I think perhaps the custom row filter that is discussed in the documentation is the way to go, but I'm a little unclear how to trigger it when the user makes a selection elsewhere and I get the "3" and "12" from that process...gotta tell the data table to row-filter the rows based on a single column containing either of those values.
Now I am completely confused?
Mike
Is this making sense? I think perhaps the custom row filter that is discussed in the documentation is the way to go, but I'm a little unclear how to trigger it when the user makes a selection elsewhere and I get the "3" and "12" from that process...gotta tell the data table to row-filter the rows based on a single column containing either of those values.
Now I am completely confused?
Mike
This discussion has been closed.
Replies