Search in Data Gird Odd Behavior

1
I have a user who's FullName is John Monroe.  I call the FullName field Display Name on the search grid and Name in the datagrid.     When I search for "john m" his record does not appear:      When I search using just "monroe", he does appear:     When I search just "John" he does appear:     What am I doing wrong?
asked
3 answers
2

I agree with Mike, there is probably some weird data regarding this particular name, as opposed to something wrong with Mendix.

Try inspecting your database and check for non-standard characters invisible control characters tabs etc.

answered
1

Jonathan,

Any chance there is more than one space between his first and last name in the FullName attribute?

Mike

answered
0

Guys,

You were right, someone put an extra space after the first name.  Is it best practice to have a "Trim" in a BCo event on these types of attributes?

Thanks!

Jonathan

answered