osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
Adding Help Topic to Open Ticket Overview on Staff Page
I figured out how to add the header for the help topic and even how to configure the sort feature. What I am having trouble with is actually getting the data from my database to populate the column I have created. I've looked at some different forum posts and even tried to supplement their $qselect and $qfrom statements with no luck.
Here is my current SELECT statement with no modifications for the help topic:
$qselect ='SELECT ticket.ticket_id,tlock.lock_id,ticket.`number`,ticket.dept_id,ticket.staff_id,ticket.team_id '
.' ,email.address as email, dept.dept_name'
.' ,ticket.status,ticket.source,ticket.isoverdue,ticket.isanswered,ticket.created ';
Here is my current FROM statement with no modifications for the help topic:
$qfrom=' FROM '.TICKET_TABLE.' ticket '.
' LEFT JOIN '.USER_TABLE.' user ON user.id = ticket.user_id'.
' LEFT JOIN '.USER_EMAIL_TABLE.' email ON user.id = email.user_id'.
' LEFT JOIN '.DEPT_TABLE.' dept ON ticket.dept_id=dept.dept_id ';
How can I change these to populate my help topic column. And also is this all that needs to be done to populate it with values?
I have also included a screenshot of my ticket overview so you can see what I am trying to do.
Any help would be greatly appreciated. Thank you!