osticket 1.9.12apache2 on ubuntu 14.04 serverYou can see the page here I am working on a public page for our techs to look at glance to see how many tickets are open and how many are closed. I would like to use a bootstrap panel  to show the 10 latest open tickets. I have the panel set up with dummy variables to show how I would like it to look. Any help would be awesome. I can connect to the database and query the database to get the info I wan,t but I just don't know how to get it to the panel. Please help.Thanks, Shaun

Do you mean something like this?http://www.tmib.net/add-client-side-open-ticket-list-osticket-18BTW I like how that looks.

Thanks, and yes exactly like that but in a different place in osticket. I could use help with the php part because I am very green in that area. I have figured out how to query the DB and get the results I want, however I have no idea how to populate the list. If anyone is interested in helping me figure it out send me a DM with your email and I will add you to my personal slack account. 

If you take a look at the include file I think that you should be able to work out a lot of your php and sql questions.

@[deleted]:I worked on this for several hours last night and I find the php you showed me confusing seeing how I am not a php guy. I found a simpler way to query and display the results but I just get the values like user_id=9 instead of Joe Smith. Any idea on how I can fix that?

I would have to see the code. :)  You can email it to me if dont want it publicly available.

Sent you an email. Anyone else interested it will be on github soon. 

As promised the link to github: https://github.com/xtheosx/OSTpublicDashRemoved some unnecessary css and added simple read me.

8 days later
Write a Reply...