Tickets List: Adding 'Category' and 'Assigned To' Column

[ZePenguin]

Hi all,

As the title goes, could someone point me how I could make the tickets list (admin view) to show additional columns such as 'Category' and 'Assigned To' please? I tried searching in the forum but they are mainly for the old ones.

FYI, I am using the latest HESK version with the latest HESK UI theme.

Thanks in advance!

[alcazar]

As for the category, just use "more options" and group the tickets by category, then you'll see it.
As for the "owner", see this thread, first post on page 2.
-> viewtopic.php?f=14&t=4571&start=15#p20977

Note: The mod is for standard hesk, modified versions can have different codes or on different places.

[lupolo]

MOD to see the category name directly in the ticket view (tested with 2.5.3)

Open: ticket_list.inc.php

Paste before

Code: Select all

echo <<<EOC

-->

Code: Select all

$ticket['category'] = $hesk_settings['categories'][$ticket['category']];

Paste before:

Code: Select all

<td><a href="admin_ticket.php?track=$ticket[trackid]&Refresh=$random">$ticket[trackid]</a></td>

-->

Code: Select all

<td class="$color">$ticket[category]</td>

Paste before:

Code: Select all

<th><a href="<?php echo $href . '?' . $query . $sort_possible['trackid'] . '&sort='; ?>trackid"><?php echo $hesklang['trackID']; ?></a></th>

-->

Code: Select all

<th class="admin_white" style="text-align:center; white-space:nowrap;"><a href="<?php echo $href . '?' . $query . $sort_possible['category'] . '&sort='; ?>category"><?php echo $hesklang['category']; ?></a></th>

[bastiaan.c]

Hi lupolo,

Thanks for this MOD. This gave me an idea.

I have made a custom field "Due Date"
Is it possible to show that field in that position?
That would be awesome
Thanks for all you do.

[lupolo]

Hi lupolo,

Thanks for this MOD. This gave me an idea.

I have made a custom field "Due Date"
Is it possible to show that field in that position?
That would be awesome
Thanks for all you do.

I think you must replace the "category" with "custom1" if its your custom field.

[bastiaan.c]

Thanks, IT WORRRRRRRKKKKKSSSSSSS!!!!

[ZePenguin]

MOD to see the category name directly in the ticket view (tested with 2.5.3)

Open: ticket_list.inc.php

Paste before

Code: Select all

echo <<<EOC

-->

Code: Select all

$ticket['category'] = $hesk_settings['categories'][$ticket['category']];

Paste before:

Code: Select all

<td><a href="admin_ticket.php?track=$ticket[trackid]&Refresh=$random">$ticket[trackid]</a></td>

-->

Code: Select all

<td class="$color">$ticket[category]</td>

Paste before:

Code: Select all

<th><a href="<?php echo $href . '?' . $query . $sort_possible['trackid'] . '&sort='; ?>trackid"><?php echo $hesklang['trackID']; ?></a></th>

-->

Code: Select all

<th class="admin_white" style="text-align:center; white-space:nowrap;"><a href="<?php echo $href . '?' . $query . $sort_possible['category'] . '&sort='; ?>category"><?php echo $hesklang['category']; ?></a></th>

Works like a charm. Thank you so much!!

[ZePenguin]

As for the category, just use "more options" and group the tickets by category, then you'll see it.
As for the "owner", see this thread, first post on page 2.
-> viewtopic.php?f=14&t=4571&start=15#p20977

Note: The mod is for standard hesk, modified versions can have different codes or on different places.

Thanks for the owner mod, I edited it to accommodate my version and it works great!

[gurdain]

Sorry, I've done the above with my custom19 field and although the column shows up....the contents are empty

I replaced every instance of category with custom19 after pasting the new lines in the correct places:

$ticket['custom19'] = $hesk_settings['custom19'][$ticket['custom19']];

<td class="$color">$ticket[custom19]</td>

<th class="admin_white" style="text-align:center; white-space:nowrap;"><a href="<?php echo $href . '?' . $query . $sort_possible['custom19'] . '&sort='; ?>custom19"><?php echo $hesklang['custom19']; ?></a></th>

These are the three lines amended by me....have I made a mistake?

[Klemen]

My suggestion is to wait just few more days as HESK 2.6.0 will be released - it will have an easy built-in way to add any field to the main page columns.

[gurdain]

Ok eagerly awaiting the update

Will there be a unified changes list version?

I've made soooo many changes to the core, I've been upgrading using the changes file for the last 4 versions

Custom statuses, custom css, custom columns, disabling customer notifications, custom language entries and notifications etc.

[gurdain]

Sorry one more thing....can the new hesk provide a ticket history for one customer....

Lets say joebloggs@gmail.com emails 10 times over a year....can i click on his name and see all his enquiries....kind of like a crm....

[Klemen]

To track changes you make and easily apply them to a new version of HESK you should use versioning software such as Subversion or Git. It's easy to generate a diff file, but so many changes (upgrading 2.5.5 to 2.6.0) take a lot of work to apply manually.

You can view the history by searching tickets by email (admin panel > find tickets form)