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

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

Like filter not working with special characters

abhiramk
11-Garnet

Like filter not working with special characters

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

 

3 REPLIES 3

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.

 

 

@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

Top Tags