Problem/Misbehavior:
The subscriber list on the /admin/people/simplenews page displays all Simplenews subscribers by default, regardless of whether they are actively subscribed to a newsletter channel. This leads to misleading results, as the list can include users who:
- Are not subscribed to any newsletter channels.
- Have inactive subscriptions (e.g., subscriptions_status = 0).
This behavior can cause confusion for administrators, who might incorrectly assume that all listed subscribers are actively subscribed to at least one channel.
Steps to Reproduce:
- Ensure that a database update has been performed after upgrading from Simplenews version 3 to version 4 (if applicable). This ensures that the subscription data has been migrated correctly.
- Ensure there are subscribers in the system who are not assigned to any newsletter channel or whose subscriptions are inactive.
- Navigate to /admin/people/simplenews.
- Leave the filter settings in their default state (do not apply any manual filters).
- Observe that the list displays all subscribers, including those with no active subscriptions.
Expected Behavior:
The subscriber list should:
- Only display users who have at least one active subscription (e.g., subscriptions_status = 1).
- Clearly differentiate between users with active subscriptions and those without.
Alternatively, the interface should explicitly indicate that the list includes all subscribers, regardless of subscription status, to avoid misinterpretation.
Actual Behavior:
All Simplenews subscribers are displayed, including those who:
- Have no newsletter channel subscriptions.
- Have inactive (subscriptions_status = 0) subscriptions.
This results in an inflated and potentially inaccurate perception of active subscribers.
Proposed Solution:
Filter Adjustment:
- Update the view query to include a condition that filters out subscribers without active subscriptions:
- Add a filter to exclude rows where subscriptions_status = 0.
- Optiona ly, exclude users who are not subscribed to any channel (subscription_id IS NULL).
Clarify Display Logic:
- Add a description or label on the page to indicate that the current view includes all subscribers by default, including inactive ones.
- Provide filtering options to display only active subscribers.
Additional Notes:
This behavior is especially problematic for administrators who rely on this list for managing newsletter campaigns, as it can lead to sending newsletters to unintended recipients or misunderstanding subscriber activity.
Version tested: Simplenews 4.x with Drupal 10.x.