I have applied a filter with the logic statements "All of these conditions must be met" and "OR all of these conditions must be met." as a default set filter from the link type in module menu. When performing a search on a field on this table, the search condition gets applied only to the last "OR" condition in the filter.
For example, if the filter is set as "X OR Y OR Z," and I apply a search condition for a selected field, it is only added to the last "OR" condition, resulting in a behavior like:
"X OR Y OR (Z AND Search condition)"
What I would like to achieve is that the search condition applies to the entire filter, such that it behaves as:
"Search condition AND (X OR Y OR Z)"
Is there a way to change this behavior to apply the search condition across all parts of the "OR" filter?
I appreciate any guidance or solution.
