Comparaison des versions

Légende

  • Ces lignes ont été ajoutées. Ce mot a été ajouté.
  • Ces lignes ont été supprimées. Ce mot a été supprimé.
  • La mise en forme a été modifiée.

...

Les tables utilisées sont :

  • sw_data_event : Table des demandes d'interventionsévénements

Les tables liées sont :
/

Critères d'activation

...

Bloc de code
languagejson
  "event": {
    "codeevent": "EXT00000001",
    "eventDate": "2021-06-04 11:03:50",
    "comment": "commande",
    "customer_ID": "C0000001",
    "baseuser_ID": "TECH2",
    "eventtype_ID": "Order",
    "customercontact_ID": "",
    "deal_ID": "",
    "label": "",
    "marketinglead_ID": ""
  }

...

Bloc de code
languagejson
  "event": {
    "codeevent": "EXT00000001",
    "eventDate": "2021-06-04 11:03:50",
    "comment": "commande",
    "customer_ID": "C0000001",
    "baseuser_ID": "TECH2",
    "eventtype_ID": "Order",
    "customercontact_ID": "",
    "deal_ID": "",
    "label": "",
    "marketinglead_ID": "",
    "gpsLongitude": "",
    "gpsLatitude": "",
    "customer_ID_dealPartner": ""   
  }

...

Bloc de code
languagejson
"filters": {
  "codeEvent": "value", filter is equal
  "label": "value", filter is contains
  "comment": "value", filter is contains
  "eventDate": "value", filter is greater or equal to
  "eventDateBetween": "value1|value2", filter is between value1 and value2
  "codeCustomer": "value", filter is equal
  "codeBaseuser": "value", filter is equal
  "codeCustomerContact": "value", filter is equal
  "codeDeal": "value", filter is equal
  "codeMarketingLead": "value", filter is equal
  "codeEventType": "value" filter is equal
},
"orderBy": "value"

Valeur Valeurs possibles pour le tri "orderBy" :

...