I have country entity, and I am not able to search Country name "Cote D'Ivoire" which contains " ' ". And in the aggregate filter say error. How can i solve that.

Thank you,

with regards.

Hi Phone,

Refer this forum post as well : https://www.outsystems.com/forums/discussion/64095/how-to-include-single-quote-in-the-aggregate-filtering/#Post251518 

Hope this helps you!


Benjith Sam


You try EncodeSql.

Hope this will be helpfull.

Vijay M-


The issue seems to be due to the generated SQL escaping single quotes with backslash instead of doubling the quotes as it should.

Another alternative to the above solutions would be to use "Cote D"+Chr(39)+"Ivoire" instead. 39 is the ASCII for single quote.