Passer au contenu principal

Updating Reports for 'is_hold' - Base de connaissances / Developer & Reporting / Creating Reports - Deskpro Support

Updating Reports for 'is_hold'

Liste des auteurs

If you have reports that reference is_hold specifically, they must be updated to use the status instead following the change to Pending Status:

BEFORE:
     WHERE tickets.is_hold = 1
 AFTER:
     WHERE tickets.status = 'pending'

Any time you reference awaiting_agent, you may want to also include pending to maintain the same results as before. (Of course, it might actually be that the proper behaviour you want is not-on-hold tickets but you just didn't think to exclude them before.)

...
 WHERE tickets.status IN ('awaiting_agent', 'pending')


Utile Peu Utile

32 personnes sur 75 ont trouvé cette page utile

Ajouter un commentaire

Veuillez vous connecter ou vous enregistrer pour soumettre un commentaire.

Mot de passe oublié ?