Changes between Initial Version and Version 1 of Ticket #8732
- Timestamp:
- 08/29/2022 07:43:12 PM (2 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #8732 – Description
initial v1 18 18 `SELECT id FROM wp_bp_xprofile_fields WHERE ... id NOT IN (123) AND id IN (123)...` 19 19 20 As a result, field `123` *will appear* `in the results (`IN` has precedence over `NOT`; see https://dev.mysql.com/doc/refman/5.7/en/operator-precedence.html)20 As a result, field `123` *will appear* in the results (`IN` has precedence over `NOT`; see https://dev.mysql.com/doc/refman/5.7/en/operator-precedence.html) 21 21 22 22 This feels counterintuitive to me. Explicit exclusion via `exclude_fields` should take precedence over implicit inclusion via `member_type`. Moreover, in the current setup, there's no reliable way to exclude `123`, except via filter.