Query filter-matching special chars.

[mvajla]

Hi, 

I'm working on some application in TWX where I would like to have filter in mashup.

Currently it is working like= Search_string is found in infotable (e.g. BCD in ABCDE string)

But, our users will also use local language string like e.g. BČD (in slovak language).

How could I achieve that I can only use search string like BCD and I will get a result from BČD? 

Original table:

Header

ABČ

XYZ

Table with search string = ABC

Header

ABČ

My current settings for filter in Service:

"filters":[
{
"type": "LIKE","fieldName": "Class","value": "%"+search_string+"%"
},

Thanks

[Ciprian-Traian]

Hi @mvajla ,

I am not sure but maybe this post can help https://community.ptc.com/t5/ThingWorx-Developers/Like-filter-not-working-with-special-characters/td-p/681277

Hope it helps,