Skip to main content
AP_958723617-Peridot
17-Peridot
Dec 21, 2021 12:31 PM UTC
Solved

query to filter in thingtemplate services

Please tell me the query format to write in this tab to filter rows.

AP_9587236_1-1640089854173.png

 

M4RCAnswer
14-Alexandrite
Dec 21, 2021 12:57 PM UTC

Hello,

you can use a command like this:

{

  "filters": {

         "type": "EQ",

         "fieldName": "CustomerId",

         "value": 2

    }

}

If necessary, use this older article as a guide for the parameters (TWX 8 doc): 

http://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/#page/ThingWorx/Help/Composer/Things/ThingServices/QueryParameterforQueryServices.html

 

View in thread

4 replies

M4RC14-AlexandriteAnswer
14-Alexandrite
Dec 21, 2021 12:57 PM UTC

Hello,

you can use a command like this:

{

  "filters": {

         "type": "EQ",

         "fieldName": "CustomerId",

         "value": 2

    }

}

If necessary, use this older article as a guide for the parameters (TWX 8 doc): 

http://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/#page/ThingWorx/Help/Composer/Things/ThingServices/QueryParameterforQueryServices.html

 

Translate
    AP_958723617-PeridotAuthor
    17-Peridot
    Jan 4, 2022 11:55 AM UTC

    Iam getting error when i given this query. What is the mistake here. @M4RC 

    {
    "filters":
    {
    "type": "AND",
    "filters": [{
    "type": "EQ",
    "fieldName": "MachineName",
    "value": MachineName
    },{
    "type": "EQ",
    "fieldName": "TaskName",
    "value":oldTaskName
    }]
    }
    };

    Translate
    M4RC14-Alexandrite
    14-Alexandrite
    Jan 4, 2022 12:18 PM UTC

    You can try this:


    {"filters":
     {
      "type": "And",
      "filters": [
         {
         "type": "EQ",
         "fieldName": "MachineName",
         "value": "MachineName"
         }, {
         "type": "EQ",

         "fieldName": "TaskName",
         "value": "TaskName"
         }

      ]

     }
    }

    Example for Values: 

    "value": "string"

    "value": 10

    "value": 1.2

     

    You need to remove the last ;

    Translate
    Terms & ConditionsAccessibility statement