Segments filters > Bounced, Unsubscribed not working

[melyouz]

Description

Segments filters called "Bounced" and "Unsubscribed" not working as exepected (not applying. No contacts are added/removed to/from the segment)

Steps to reproduce

• Create a Segment with filter "Unsubscribed" => Yes
• Unsubscribe a Contact (manually or from email link)
• Update segment contacts app/console mautic:leadlist:update
• 0 Contacts added to the Segment

[BartKaminski]

Same problem with Bounced filter

[peteratnsight]

The issue is caused by

LeadListRepository at line 772: $q->expr()->eq($alias . '.channel', $channel) with $channel defined as 'email' in line 758 => causing a select query as .channel = email ....

Quick fix - change 758 to $channel = '"email"';

But the query expression definition certainly needs to be fixed for this.

[tiagorodriguesdev]

+1

Quick fix offered by @peteratnsight worked.

[alanhartless]

This is fixed by #1836.

[tiagorodriguesdev]

Thanks @alanhartless