Search on custom field does not work

[Arunas]

Hey guys,

I have added custom (varchar) field in account section.
I enabled search on this field

however if I try to search for it give me empty result.

what could be wrong?

[yuri]

Works properly. Just tested. Please more details. Not clear what you do.

[Arunas]

Works properly. Just tested. Please more details. Not clear what you do.

go to admin -> field manager -> account -> add new field (varchar)
give it a name accountID
add new field to layout -> "List" and enable in "Search Filters" section.
populate with data and try to search.
for me it didn find anything

[Arunas]

Just tried to search based on website field it doesn;t work either

[yuri]

Ok. I will look. Thanks.

[yuri]

Do you try to search by the beginning of the value? If value "Hello World" then search "Hello" ?

[Arunas]

Do you try to search by the beginning of the value? If value "Hello World" then search "Hello" ?

yes, it find records if you search begining of value in account name field, but if you try to search end of value it will not find.
Example
account name = Comany, LTD
search = com -> search result true
search = LTD -> search result false

search done against custome fields fails with any search (beginig, middle, end)

[yuri]

Search by '%LTD'

Please make sure about custom fields. They should work as well.

[Arunas]

Search by '%LTD'

Please make sure about custom fields. They should work as well.

%LTD did the trick, thanks. But why not * symbol as wildcard?

[yuri]

% is used in LIKE operator. Maybe will remove the need to add it in the next version.

[Arunas]

% is used in LIKE operator. Maybe will remove the need to add it in the next version.

I would give +1 for % removal