Filtering on email address

ckndr47

Hello everybody,

I have a codeunit through which i am filtering customer record with respect to customer email address. Now i am unable to search/filter those records with respect to email address.

One notable thing i have concluded;
If i have a customer with an email address as: test@mibuso.com
now if i will apply search filter with respect to test@mibuso.com, then the search wont return anything; now instead of searching with test@mibuso if i will search that email address without @ like testmibuso then search will return that customer information.

Either thats a bug; or my mistake. If you have any idea, then please come up some suggestion.

Thanks and Regards,

amunozsu

Hi,

The character '@' makes the search case insensitive so it is going to be removed from the search.

-- Alejandro --

ckndr47

then whats the alternate?

kriki

The only thing I found is using this as filter :"test?mibuso.com"
The ? replaces 1 character. Of course this filter will also show "testXmibuso.com".

ckndr47

Exactly i have also figured out the same solution, but i guess there is no alternate other then that.

Thanks and Regards,

ara3n

The alternative solution would be to have a new field that would copy the the exact data as the email address and skip the @ sign.
onvalidate of the email field you could populate the field.

so
test@mibuso.com
would be
test_at_mibuso.com

or test,mibuso.com

what ever you want it to be to make filtering easier.