Skip to main content
ejae1-Visitor
1-Visitor
July 27, 2016
Solved

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

  • July 27, 2016
  • 3 replies
  • 2263 views

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.

Best answer by supandey

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

3 replies

supandey5-Regular Member
5-Regular Member
July 27, 2016

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-21-Visitor
1-Visitor
July 28, 2016

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.

supandey5-Regular MemberAnswer
5-Regular Member
July 28, 2016

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

Terms & ConditionsAccessibility statement