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

Purpose of Search Expression in Search Data table Entries

SOLVED
Highlighted
Alexandrite

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
Highlighted

Re: Purpose of Search Expression in Search Data table Entries

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
Highlighted

Re: Purpose of Search Expression in Search Data table Entries

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

Highlighted

Re: Purpose of Search Expression in Search Data table Entries

Thank You  Vel kumar.

 

Highlighted

Re: Purpose of Search Expression in Search Data table Entries

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

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!