Query filter-matching special chars.
Dec 21, 2020
04:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dec 21, 2020
04:42 AM
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
Labels:
- Labels:
-
Coding
1 REPLY 1
Dec 23, 2020
10:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dec 23, 2020
10:08 AM
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,
