Filter 'Email address not contains "value" ' is not working in Smart list | Community
Skip to main content
K
kirtiag1
Level 2
September 23, 2024
Solved

Filter 'Email address not contains "value" ' is not working in Smart list

  • September 23, 2024
  • 2 replies
  • 1617 views

Hey Folks, I’ve noticed that the filter “Email address does not contain = @xyz.com” in the smart list is not functioning as expected. It is not suppressing any records. The count in the database matches the smart list count, even when I use multiple domains for suppression. It's only working on using “Email address does not contain = xyz.com” and that is not a best practice to not use "@" in domain.

It seems like there might be a bug in the instance.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

When you use [contains] and any item in the list starts with “@”, the whole filter changes ends-with mode and all items are treated as ends-with matches. This creates surprising behavior.

 

Therefore you must not put full email addresses and @domains in the same filter. Move them into separate filters.

2 replies

uditmathur
Community Advisor
uditmathurCommunity Advisor
Community Advisor
September 23, 2024

Hi @kirtiag1 ,

Filter is working perfectly at my end.

May be you should check if your smart list criteria is correct, else i will suggest to raise a support ticket.

 

 

 

    K
    kirtiag1Author
    Level 2
    September 24, 2024

    Thanks @uditmathur ,

    My concern is; I am using @xyz.com and kirti@abc.com both in my SL but it is not suppressing any record, even "kirti@abc.com".

     

    I have already raised the ticket to support but haven't recieved any strong point from them yet.

     

    Thanks!

    Ishita_Chawra
    Ishita_Chawra
    September 24, 2024

    @kirtiag1 Hi,

    say you are suppressing a smart list then you would use the smart list filters as below for suppressing. 
    You will have to use separate filters for @xyz.com and kirti@abc.com as below and logic should be ALL. It worked for me when I tested. 
    Hope this helps!

    SanfordWhiteman
    SanfordWhitemanAccepted solution
    Level 10
    September 25, 2024

    When you use [contains] and any item in the list starts with “@”, the whole filter changes ends-with mode and all items are treated as ends-with matches. This creates surprising behavior.

     

    Therefore you must not put full email addresses and @domains in the same filter. Move them into separate filters.

    Terms & ConditionsAccessibility statement

    Loading footer...