Skip to main content
A
abhiramk1-Visitor
1-Visitor
August 7, 2020
Solved

Like filter not working with special characters

  • August 7, 2020
  • 3 replies
  • 2331 views

Hello,

 

When i'm filtering the things using the like filter which contains special characters, it's not returning any results. I have tried using escape characters still no result.

Did anyone face this issue? How did you overcome this? 

 

var filterPattern = "Thingworx Navigate (TN)";
var params = {
inclusive: true /* BOOLEAN */,
fieldName: "Organization" /* STRING */,
t: Devices /* INFOTABLE */,
pattern: filterPattern + "*" /* STRING */,
};

var result = Resources["InfoTableFunctions"].LikeFilter(params);

 

-thanks,

Abhiram

 

Best answer by CharlesJi

Hi @abhiramk, in this case, you may try to use a double backslash "\\" to escape the special characters.

var filterPattern = "Thingworx Navigate \\(TN\\)";

 

3 replies

R
Rocket_Max17-Peridot
17-Peridot
August 11, 2020

Hello @abhiramk 

I suspect that wildcards are not supported in InfoTableFunctions

.

 
 

Snipaste_2020-08-11_11-00-26.png

http://support.ptc.com/help/thingworx_hc/javadoc/com/thingworx/resources/queries/InfoTableFunctions.html?wwreverbsearch_action=search_display_link&wwreverbsearch_highlightRequireWhitespace=false&wwreverbsearch_query=LikeFilter

 

BR,

Max

A
abhiramk1-VisitorAuthor
1-Visitor
August 11, 2020

Thanks Max for your response.

As per my understanding LikeFilter is to filter infotable rows based on columnValue matching the pattern(will provide wildcard character to filter) we provided right, my infotable is having string values only which contains special characters. It's working with string which doesn't contain spcl char's but not giving an error or response if it contains special characters.

 

 

A
abhiramk1-VisitorAuthor
1-Visitor
August 12, 2020

@CarlesColl converting it to JSON and applying javascript filter and converting back to Infotable. Other than this any workarounds are possible. Can you please provide your inputs?

 

-thanks,

Abhiram

C
CharlesJi16-PearlAnswer
16-Pearl
November 18, 2024

Hi @abhiramk, in this case, you may try to use a double backslash "\\" to escape the special characters.

var filterPattern = "Thingworx Navigate \\(TN\\)";

 

Terms & ConditionsCookie settingsAccessibility statement