Purpose of Search Expression in Search Data table Entries

[Sathishkumar_C]

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.

[Velkumar · Accepted solution]

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

[Sathishkumar_C]

Thank You  Vel kumar.

[reedsch]

Thank you for yet aother partial answer that requires additional information seeking, which seems to be the standard on this website.