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

Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! 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

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

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