I made the datatable and insert data (different language, Korean) and executes SearchDataTableEntries with korean expressions.
I have no results.
Is it possible to use the service with korean expressions ?
My thingworx Versions is 7.
Solved! Go to Solution.
Hi Kyung, do you mean something like this
I used the SearchDataTableEntries Service to get the data with the exception that instead of SearchExpression parameter i am using the Query and this is what i pass to the SearchDataTableEntries : see below
var query = {
"filters": {
"fieldName": "stringCol1",
"type": "LIKE",
"value": searchString
}
};
var params = {
maxItems: 100 /* NUMBER */,
//searchExpression: /* STRING */
query: query /* QUERY */,
//source: undefined /* STRING */,
//tags: undefined /* TAGS */
};
// result: INFOTABLE dataShape: "undefined"
var result = me.SearchDataTableEntries(params);
I think the searchExpression will also work, it's just about figuring out the syntax for that as well.
In the meantime hope this helps
Hi Eunkyeung, could you please share the search expression you are formulating to get the data out of the data table? Just as a side question are you able to pull all the data you inserted into the Datatable i.e. without applying any expression to filter the result?
Hello, Pandey
You can try with 서울 as an expression, also as an entry. And yes, all result shows up without an expression.
There is no problem when I tried QueryDataTableEntries or FindDataTableEntries (search inputs as infotable), but SearchDataTableEntries seems to be a problem.
Hi Kyung, do you mean something like this
I used the SearchDataTableEntries Service to get the data with the exception that instead of SearchExpression parameter i am using the Query and this is what i pass to the SearchDataTableEntries : see below
var query = {
"filters": {
"fieldName": "stringCol1",
"type": "LIKE",
"value": searchString
}
};
var params = {
maxItems: 100 /* NUMBER */,
//searchExpression: /* STRING */
query: query /* QUERY */,
//source: undefined /* STRING */,
//tags: undefined /* TAGS */
};
// result: INFOTABLE dataShape: "undefined"
var result = me.SearchDataTableEntries(params);
I think the searchExpression will also work, it's just about figuring out the syntax for that as well.
In the meantime hope this helps