Find in Portal- Problem

[dav1089]

Hi,

I have Contacts portal on Company layout. Now, I can do FIND in other fields of the portal but email field., I already checked inspector > Field Entry in find mode is cheked..

I have attached screenshots 

 

[Steve Martino]

Try putting it in quotes

[dav1089]

Hah! it did the magic...thanks Steve.. 

[David Jondreau]

Unfortunately, @ is a special symbol in find mode. Quotes works. Also changing the fields storage settings to Unicode (though then upper and lower case letters will be treated differently). It's a problem.

[comment]

The problem here is that the "@" character is a special symbol in Find mode. And the solution is to escape it when you want to search for the actual "@" character - i.e. search for:

myemail\@email.com

 

3 hours ago, Steve Martino said:

Try putting it in quotes

That will work - but it is a very expensive solution, since searching for literal text does not use the index.

 

Edited April 7, 2016 by comment

[Steve Martino]

1 hour ago, comment said:

 

3 hours ago, Steve Martino said:

Try putting it in quotes

That will work - but it is a very expensive solution, since searching for literal text does not use the index.

I did not know that.  How about if you script it via a Perform Quick Find?  It finds the email and you don't need the quotes, but does it use the index?

[comment]

8 hours ago, Steve Martino said:

How about if you script it via a Perform Quick Find? 

What would be the advantage of that? The disadvantage obviously being that all fields enabled for Quick Find would be searched.

8 hours ago, Steve Martino said:

but does it use the index?

I presume it does (or it wouldn't be quick).