Hi,
Using single quotes in filters from the client via the jsdo does not work as the query string gets two single quotes passed to the back-end. For example trying to search for customers where name begins "O'Conn" causes the filter string to be represented as 'O''Conn'.
Are there any plans to change progress.util._convertToABLWhereString to support single quotes appropriately ?
Regards
In addition to Manjinder's findings, I was able to fix the issue by adding the replace method here withint the _convertToABLWhereString function:
// We need to build a template format string for the where string. // We'll first add positional info for the value if (type === STRING_OBJECT_TYPE) { // Mike Fechner, 15.04.2016 - potential fix for SCL-1277, problem with filter values // containing single quotes value = value.replace("'", "~047"); format = "'{1}'"; }
You should enter a bug for this
Maura