Gå till huvudinnehåll

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

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

Författarlista

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.

Hjälpfull Oanvändbar

38 av 77 personer tyckte att sidan var användbar

Posta en kommentar

Logga in eller registrera dig för att lämna en kommentar.

Behöver du en påminnelse om ditt lösenord?