Search fields get escaped


Here’s the issue: when filling a search field with single quoted value (O’hara…) it gets escaped after clicking on the next page button or ordering a column.

After the second click, the searching lead to an empty result, because the field has become O\'hara.

Hope to see that fixed or any other solution.

Thanks to all

Thanks for highlighting this issue.

We’ll log this as a bug.



This a known sugar bug which is still in Sugar CE.

Seems to be caused by include/database/MssqlManager.php line 257 where they call mysqli_real_escape_string on the search query.

Not sure about a fix yet.