Skip to main content
R
Rayon_1111-Garnet
11-Garnet
November 1, 2023
Solved

Query to filter the data based on name

  • November 1, 2023
  • 1 reply
  • 874 views

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

 

Best answer by Velkumar

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

1 reply

V
19-Tanzanite
Velkumar19-TanzaniteAnswer
19-Tanzanite
November 2, 2023

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

    Terms & ConditionsAccessibility statement