Hello

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!


Regards,

Benjith Sam

Hi,

You try EncodeSql.

Hope this will be helpfull.


Vijay M-

Hi,

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.