I have a table of data that I am showing to users and I want them to be able to filter the data to show only rows that contain word A or word B or word C etc. e.g. only show me rows that have Jane or Fred in the forename field.
I currently have a multiline input that lets users add the words they want to filter on and I have a filter setup that uses ‘contains keyword(s)’.
My issue seems to be that this only shows results that contain word A AND word B AND word C but what I want to show is results that contain word A OR word B OR word C.
Is there a way of doing this?