OK. All the operations should be done by the https://handsontable.com/docs/7.4.2/Filters.html#addCondition method using one of those operations
Possible operations on collection of conditions:
conjunction - Conjunction on conditions collection (by default), i.e. for such operation: c1 AND c2 AND c3 AND c4 … AND cn === TRUE, where c1 … cn are conditions.
disjunction - Disjunction on conditions collection, i.e. for such operation:
c1 OR c2 OR c3 OR c4 ... OR cn === TRUE, where c1, c2, c3, c4 … cn are conditions.
disjunctionWithExtraCondition - Disjunction on first
n - 1 * conditions from collection with an extra requirement computed from the last condition, i.e. for such operation:
c1 OR c2 OR c3 OR c4 ... OR cn-1 AND cn === TRUE, where c1, c2, c3, c4 … cn are conditions.
The last one sounds exactly as your case, so I highly encourage you to give it a try and if you’d have any issue with that implementation please share the latest version of the demo and I’ll do my best to share some valuable tips.