query to filter in thingtemplate services

[AP_9587236]

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

[M4RC · Accepted solution]

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

[AP_9587236]

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
}]
}
};

[M4RC]

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 ;

[AP_9587236]

Thank you