Show Helptopic in Ticketlist - Help needed / v1.10RC2

bR4iNd3a7h

Hi everybody,

I'm using osticket v1.10RC2 and I like to show the helptopic in the ticketlist, but I'm only able to show the ID of the helptopic.

Can somebody help me to join the database tables 'ost_ticket' and 'ost_help_topic to show the helptopic instead of the topic id?

Thanks for your help in advance

blank

ntozier

What's the query your using?I imagine that you would want to display 'topic' instead of 'topic_id'.

bR4iNd3a7h

I have added 'topic_id' in line 305:

// Select pertinent columns// ------------------------------------------------------------$tickets->values('lock__staff_id', 'staff_id', 'isoverdue', 'est_duedate', 'topic_id', 'team_id', 'ticket_id', 'number', 'cdata__subject', 'user__default_email__address', 'source', 'cdata__priority__priority_color', 'cdata__priority__priority_desc', 'status_id', 'status__name', 'status__state', 'dept_id', 'dept__name', 'user__name', 'lastupdate', 'isanswered', 'staff__firstname', 'staff__lastname', 'team__name');// Add in annotations

And i have added the following in line 475:

using 'topic' instead of 'topic_id' returns the same results

ntozier

topic_id != topic.

bR4iNd3a7h

I know, but if i use topic i get the same results. topic also returns the topic-id because the column 'topic' in the table 'ost_ticket' contains the topic id an not the plaintext of the chosen helptopic.

ntozier

Help Topics are stored in ost_help_topic. You would use the topic_id to look up the topic there.

bR4iNd3a7h

That is exactly what i wrote in the first post of this thread.But i don't know the php-syntax for joining the to tables to look up the topic in the other table.

ntozier

SELECT topic FROM ost_help_topic WHERE topic-id=$value