Passer au contenu principal

My report has stopped working with an "Unknown column reference tickets.charges.comment" error (Old) - Base de connaissances / Developer & Reporting / Creating Reports - Deskpro Support

My report has stopped working with an "Unknown column reference tickets.charges.comment" error (Old)

Liste des auteurs

Question:

My existing report about ticket time log & billing has recently stopped working with an error about "Unknown column reference tickets.charges.comment".

 

Answer:

The variable to include a ticket report comment changed in Deskpro #413 when it became possible to add custom fields to charges.

Update your report, replacing tickets.charges.comment with tickets.custom_data[1].

 

If that doesn't work, check the ID of the comment field under Tickets > Time Log & Billing > Fields.

 

 

Replace the 1 in tickets.custom_data[1] with the number shown next to Comment.

Utile Peu Utile

38 personnes sur 77 ont trouvé cette page utile

Ajouter un commentaire

Veuillez vous connecter ou vous enregistrer pour soumettre un commentaire.

Besoin d'un rappel de mot de passe?