Zum Hauptinhalt springen

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

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

Autorenliste

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.

Hilfreich Nicht hilfreich

38 von 77 Personen fanden diese Seite hilfreich

Fügen Sie einen Kommentar hinzu

Bitte loggen Sie sich ein oder melden Sie sich an, um einen Kommentar zu hinterlassen.

Benötigen Sie eine Passwort-Erinnerung?