Skip to main content
13-Aquamarine
December 21, 2020
Question

Query filter-matching special chars.

  • December 21, 2020
  • 1 reply
  • 858 views

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

5-Regular Member
December 23, 2020

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,