cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X

Purpose of Search Expression in Search Data table Entries

Sathishkumar_C
17-Peridot

Purpose of Search Expression in Search Data table Entries

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.

1 ACCEPTED SOLUTION

Accepted Solutions

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

 

View solution in original post

3 REPLIES 3

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

 

Thank You  Vel kumar.

 

reedsch
4-Participant
(To:Velkumar)

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

Top Tags