portal Query Builder produces incorrect results for boolean any operator

[mbjones]

Describe the bug
When building a data collection query in the portal Query Builder, using the 'any' dropdown produces incorrect results. It appears the multiple query rules are AND'ed rather than being OR'ed. This bug was reported by an ADC user, and verified through several variants by @mbjones

To Reproduce

1. Create test portal
2. Open the Data tab to edit the collection query to use a single rule, note query result count (e.g., creator contains 'Nash')
3. Add a second rule that expands the query (e.g., All Metadata contains 'Alaska') and used they 'any' operator
4. Note that the query resultset gets smaller rather than larger

Expected behavior
An OR'ed query generally should be the same size or larger.

Screenshots

First query, 9 results:

Second query: 8 results (should be > 4,084 and < 4093

For any two subqueries that produce results with counts of x and y, the OR'ed query should produce at least as many as the larger resultset, and potentially as many as x+y combined. This could probably be encoded in a test to ensure the system does not regress.

Desktop (please complete the following information):

• OS: MacOS
• Browser: Firefox 132.0