data table search use AND instead of OR

visceralist

hi there.

I am wondering how can I override the default search functionality in data tables to use AND when typing two keywords instead of OR.

thank you

tangerine

I'm not sure, but have you tried chaining two "->where(...)" statements?

allan

Can you link us to the page in question please (as noted in the forum rules)? DataTables does do AND filtering by default, not OR, so there is something else going on here.

Allan

visceralist

hey thank you for the responses and my apologies for that implicit ignoring of the rules. I couldn't post a screenshot/sample because it is behind a company wall and can't be accessed.

I hhave now learned that there are other pages where the filtering works just fine on the basis of AND. the pages where datatables do OR filtering have been manually tweaked to have OR filtering instead of the (default) AND.

I just need to know where do I put that back from OR to default AND.
cheers,