I want to know the way how to search in a different language

[ejae]

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.

[supandey]

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?

[kyang-2]

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.

[supandey · Accepted 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