There is a DataTable as below. How to get rows containing "%" ? ID Value 1 %1 2 2? 3 * 4 +1 In above case, should be the 1st row. Because % is a wildcard in Thing Query, how should I escape it? Same question for ? and *.

16-Pearl

Solved

How use set wildcard characters [? % *] as target character in ThingWorx Query with "Like" filter?

Forum|Forum|8 years ago
July 12, 2018
3 replies
2356 views

There is a DataTable as below. How to get rows containing "%" ?

ID	Value
1	%1
2	2?
3	*
4	+1

In above case, should be the 1st row.

Because % is a wildcard in Thing Query, how should I escape it?

Same question for ? and *.

Best answer by mneumann

Try the following code to just return the "%1" line

var query = {
 "filters": {
 "fieldName": "value",
 "type": "LIKE",
 "value": "\\u0025" + "1"
 }
};

var params = {
	query: query /* QUERY */
};

// result: INFOTABLE dataShape: "undefined"
var result = me.QueryDataTableEntries(params);

The % is unescaped into \\u0025 to reflect the hex number of the character

https://www.ascii.cl/htmlcodes.htm

For me it returned only this one row out of

%1
2?
*
+1
11
12
21
22

M

mneumann