Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

Display Currently Open Tickets In A PHP Table

Hi,

We use osTicket at my college and I've been working on a PHP app to display currently open tickets alongside when they were opened and who they are assigned to on a monitor in the IT room so we can see at a glance who has what to do.

Unfortunately, my SQL isn't good enough to build a query that works reliably. I've had it working but every time I do something stops working. For example, I can pull all open tickets but unassigned tickets now don't get added to the list. 


Although it doesn't look to me that the SQL database works the same way in the newer versions. The forum post here: http://osticket.com/forum/discussion/9248/show-open-tickets-to-public/p1 seems to suggest that this was a planned feature in 2013, has it been implemented and I'm just missing it?

Thanks
Tagged:

Comments

Sign In or Register to comment.