cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X

Query filter-matching special chars.

mvajla
12-Amethyst

Query filter-matching special chars.

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

 
1 REPLY 1

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,

 

Top Tags