yes, it's possible.

Hi,

not that complicated, just follow those steps. Please note that the line numbers might be a bit different according to yours:

- open include/staff/tickets.inc.php

- search for $qselect (should be around line 209) and modify the query string that it looks like that at the end (basically it's just ticket.helptopic added) ..... ticket.created,pri.* ,count(attach.attach_id) as attachments, ticket.helptopic ';

- scroll down to around line 396 and add the table header for the Helptopic, so it looks like

<th width="280">Subject</th>

<th width="80">Helptopic</th>

- again scroll down a bit (around line 440) and add the following line just before the dept_name table cell, so it looks like

<td nowrap><?=Format:($row)?></td>

<td nowrap><?=Format:($row,30)?></td>

You might play around with the table cell width to fit it to your liking.

Best

T.

It works! Now how do I get it to sort?

Hi,

not that complicated, just follow those steps. Please note that the line numbers might be a bit different according to yours:

T.

Hey,

thanks for a great writeup on how to add the Topic.

I do need some help to figure out the rest of the code to allow it to sort. I tried a few things but i am no PHP pro and cant seem to get it to work correctly.

I understand that to sort by topic and allow that field to activate as a link you would need the following code

<th width="70"><a href="tickets.php?sort=topic=<?=$negorder?><?=$qstr?>" title="Sort By Topic <?=$negorder?>">Topic</a></th>

What i am not sure about is what i modified here

"tickets.php?sort=topic=

And if that were correct, do i need to add additional code or topic&order

or is there even more i am missing to get this to work?

Any help would be appreciated.

-Phil

Hi ;)

I need to do something like this, but the code didn´t work D:

I´m using the spanish mood.

i don´t know what am i doing wrong...

Notes:

i´m already modify my mood to add the staff asigned to each ticket, and i try to do the same but i can´t

These directions are for 1.6ST. If your not running that version then you will have figure out how to change the mod to match your version. Every MOD changes the source which means things end up on different lines, since you are using a modded version you will have to use CTRL-F in your files and scroll a bit to figure out where to add the snippets provided.

Side note: You should really upgrade to 1.7ST. Although there is not currently a hard end of support for 1.6ST that I'm aware of it will continually get harder to find people to help you with it since people are upgrading.

These directions are for 1.6ST. If your not running that version then you will have figure out how to change the mod to match your version. Every MOD changes the source which means things end up on different lines, since you are using a modded version you will have to use CTRL-F in your files and scroll a bit to figure out where to add the snippets provided.

Side note: You should really upgrade to 1.7ST. Although there is not currently a hard end of support for 1.6ST that I'm aware of it will continually get harder to find people to help you with it since people are upgrading.

oh...sorry for the problems...

about upgrade the sistem, i´m already propouse it to my boss, but we think that we habe problems ´cuz he have modify the db...

he ask me abot if he can show the new function of the new version in the page of osticket... but i don´t found some video or some like that.

it is because he wants to get some graphs... and its looks like the new version can do it...

well tanks for your time

If it were me I would setup an internal only site with a fresh install of the new version (copy your old database and upgrade it to the new one) so that you can showcase the new version to your boss.