Searching Customers using their Email ID

Banani

Hello all,
My key concern is searching customers by their email id. I should be able to search using the @ symbol and not replace it with ? symbol. Please do let me know if any alternative exists. I should be able to search on email id's with the actual format for example Tina@gmail.com and NOT Tina?gmail.com

Regards

David_Cox

Hi,
The '@' symbol is used for 'case insensitive' in filters like @*John* which returns John Smith, fred.johnson, john etc:, so this is possibly the reason the '@' search will not work.

I think you already have the soulution and reason, in classic if it is on a list view then F7 and entering @*Tina* will find all the Tina's in the list, in RTC filtering the list on Tina will do the same.

HTH

David

Banani

Thanks David,
Is there any other way where in I am able to search email ID's using @, Angel @gmail.com in RTC. The users will be confused if they have to replace @ with ? in order to search by email ID.


Regards
Banani

gonzy1981

Hi Banani,
Did you solve this issue!! I'm dealing with the same junk! ](*,) ](*,)

TonyDuarte

Banani wrote:

Thanks David,
Is there any other way where in I am able to search email ID's using @, Angel @gmail.com in RTC. The users will be confused if they have to replace @ with ? in order to search by email ID.


Regards
Banani

I made a simple test in RTC in the Customer List, using: *@cronuscorp.net, retrieving all that have cronuscorp.net as email domain, and 3 or 4 records didn't show because of not having email configured and another one were I have changed the *@cronuscorp.net to *@cronusorp.net, and only found 1, can this help in anyway?

gonzy1981

Hi,
Eventually my client is going to use this sort of filters: nigel*@chronus.net.

Kishorm

Have you tried enclosing it in single quotes, I.e. In the filter box instead of entering...

Fred@hotmail.com

...you enter...

'Fred@hotmail.com'

aniish

You can use either ? or * instead of @, like if you want to search abc@gmail.com then you can replace it either as abc?gmail.com or abc*gmail.com.