Skip to main content
S
Sathishkumar_C17-Peridot
17-Peridot
March 1, 2018
Solved

Purpose of Search Expression in Search Data table Entries

  • March 1, 2018
  • 1 reply
  • 3882 views

Hi All,

How usefull Search Expression in Search Data table Entries?

 

var params = {
 maxItems: undefined /* NUMBER */,
 searchExpression: undefined /* STRING */,
 query: undefined /* QUERY */,
 source: undefined /* STRING */,
 tags: undefined /* TAGS */
};

// result: INFOTABLE
var rawdata = Things["En.KPIList"].SearchDataTableEntries(params );

How to use  searchExpression Parameter??

Any Example??

 

Thanks & Regards,

Sathishkumar C.

    Best answer by Velkumar

    Hello Sathishkumar,

     

    "SearchExpression" can be used to create query for key values in Datatable.

     

    For example:

    You have DataTable with 5 key rows as

    1. Room1Temperature1

    2. Room2Temperature1

    3. Room1Temperature2

    4. Room1Temperature3

    5 .Room2Temperature2

     

    If you want only Room1 data, you can give search expression as "Room1*". It will result only Room1 rows.

     

    PFA the PNG for operators used in SearchExpression

     

    Regards,

    Velkumar R

     

    1 reply

    V
    Velkumar19-TanzaniteAnswer
    19-Tanzanite
    March 2, 2018

    Hello Sathishkumar,

     

    "SearchExpression" can be used to create query for key values in Datatable.

     

    For example:

    You have DataTable with 5 key rows as

    1. Room1Temperature1

    2. Room2Temperature1

    3. Room1Temperature2

    4. Room1Temperature3

    5 .Room2Temperature2

     

    If you want only Room1 data, you can give search expression as "Room1*". It will result only Room1 rows.

     

    PFA the PNG for operators used in SearchExpression

     

    Regards,

    Velkumar R

     

      S
      Sathishkumar_C17-PeridotAuthor
      17-Peridot
      March 2, 2018

      Thank You  Vel kumar.

       

      Terms & ConditionsAccessibility statement