There may be a problem in the search functionality. I search for names beginning with "Dan" in the sports database and choose "Dan's" and i get an error in the query. I think it is because there is an apostrophe in the name.
Can anyone else verify this as an error?
Thanks!
-dan
Hello Dan,
There is currently an issue when using apostrophes / single quotes in a query.
Here is a workaround / fix.
You could try updating the function _convertToABLWhereString() in progress.all.js (near line 410) and update the code to look like the following:
// 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) {
format = "'{1}'";
value = value.replace(/'/g, "~'");
}
Please let me know how it goes if you try it out.
I hope this helps.
Thanks.
Hello Dan,
There is currently an issue when using apostrophes / single quotes in a query.
Here is a workaround / fix.
You could try updating the function _convertToABLWhereString() in progress.all.js (near line 410) and update the code to look like the following:
// 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) {
format = "'{1}'";
value = value.replace(/'/g, "~'");
}
Please let me know how it goes if you try it out.
I hope this helps.
Thanks.
Thanks! I will try your suggestion Edsel. I can demo around it in the interim :)
i applied this change in progress.all.js in resources\web\scripts\progress.all.js and it appeared to fix the issue.
thanks.