...
Bloc de code | ||
---|---|---|
| ||
"filters:" {
"codeEquipment": "value", filter is equal
"description": "value", filter is contains
"serialNumber": "value", filter is equal
"equipmentType": "value", filter is equal
"equipmentKind": "value", filter is equal
"codeCustomerAddress": "value", filter is equal
"codeEquipmentStatus": "value", filter is equal
"equipmentNotClosed": "value", filter is codeEquipmentStatus <> 'DELETED' and (terminationDate is null OR terminationDate >= value)
"useModuleCold": "value", filter is equal (if value = "1" return only equipments that use cold characteristics)
"codeEquipmentParent": "value", filter is equal
"locationCodeCustomerAddressAndDate": "value1&value2", filter is codeCustomerAddress = 'value1' AND (ea.startDate IS NULL OR ea.startDate <= 'value2') AND (ea.endDate IS NULL OR ea.endDate >= 'value2') // ea = sw_data_equipmentaddress
},
"orderBy": "value" |
Valeurs possibles pour le tri "orderBy" :
...