i want to customize the ticket export csv need to add new column in csv

narendraidrive

I'm trying to fetch the last thread entry with the title "Issue updated" and include its body content in the CSV export. For this, I plan to introduce a new column labeled "Private Note".

I've added the following line to class.queue.php at line 619
'private_note' => __('Private Note'),
However, I'm unsure where to implement the logic to fetch the thread body that matches the "Issue updated" title. Could someone point me to the correct file or method for handling this query?

Also, is it even possible to add a custom column like this to the CSV export?

narendraidrive

os ticket version details

narendraidrive

Also, I noticed that the Thread Count column in the ticket CSV export is always blank, even though many tickets have multiple threads.

KevinTheJedi

narendraidrive

You cannot include thread entry content in a CSV export. You would need to modify the codebase. When modifying the codebase you are always on your own as you are deviating from core. You will proceed at your own risk. Good luck!

Also, count columns/annotations are currently borked so that’s why it’s blank.

Cheers.

narendraidrive

Can you pls let me know
Where is the logic of the below code to fetch data

    $fields = array(
            'number' =>         __('Ticket Number'),
            'created' =>        __('Date Created'),
            'cdata__subject' =>  __('Subject'),
            'user__name' =>      __('From'),
            'user__emails__address' => __('From Email'),
            'cdata__priority' => __('Priority'),
            'dept_id' => __('Department'),
            'topic_id' => __('Help Topic'),
            'source' =>         __('Source'),
            'status__id' =>__('Current Status'),
            'lastupdate' =>     __('Last Updated'),
            'est_duedate' =>    __('SLA Due Date'),
            'sla_id' => __('SLA Plan'),
            'duedate' =>        __('Due Date'),
            'closed' =>         __('Closed Date'),
            'isoverdue' =>      __('Overdue'),
            'merged' =>       __('Merged'),
            'linked' =>       __('Linked'),
            'isanswered' =>     __('Answered'),
            'staff_id' => __('Agent Assigned'),
            'team_id' =>  __('Team Assigned'),

so that I can customize the code,
for example 'merged' => __('Merged'),
Where is the main logic of this line for fetching the merge record for each ticket?

KevinTheJedi

narendraidrive

When modifying the codebase you are always on your own as you are deviating from core. You will proceed at your own risk.