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

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

Query to filter the data based on name

Rayon_11
11-Garnet

Query to filter the data based on name

Hi All,

I am new to the TWX but I have a doubt like I have a data base and I want to filter the data based on different filter criteria like I want to filter it based on a Product Name (string) attribute please help me to write a query for that if possible just any random query 

 

Regards,

Rayon

 

ACCEPTED SOLUTION

Accepted Solutions
Velkumar
19-Tanzanite
(To:Rayon_11)

Hi @Rayon_11 

 

If you are using external DataBase - SQL WHERE Clause (w3schools.com)

 

For Thingworx Query - Query Parameter for Query Services (ptc.com)

 

You can also generate a Query using "Create Query For InfoTable" snippet.

 

/VR

View solution in original post

1 REPLY 1
Velkumar
19-Tanzanite
(To:Rayon_11)

Hi @Rayon_11 

 

If you are using external DataBase - SQL WHERE Clause (w3schools.com)

 

For Thingworx Query - Query Parameter for Query Services (ptc.com)

 

You can also generate a Query using "Create Query For InfoTable" snippet.

 

/VR

Announcements


Top Tags