I have a fairly straightforward DataTable that I need to be able to filter on multiple columns with multiple terms for each column, and each term may be multiple words.
In other words, I might need to filter column 1 for the terms "foo bar" and "beiber", which should result in showing only rows with either "foo bar" or "beiber" in column 1. It should ignore "foo" and "bar" in column 1.
In addition, I might broaden my catch by adding additional terms on column 2 or column 3 (using the same approach).
Is this possible? Is this a case of building a custom filter plugin? :-(