Akeeba Ticket System

#32210 Get category information

Posted in ‘Akeeba Ticket System for Joomla! 4 & 5’

This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version

n/a

PHP version

n/a

Akeeba Ticket System version

n/a

Latest post by on Wednesday, 05 February 2020 17:17 CST

Saturday, 04 January 2020 06:37 CST

maka45

Hi

How can i get (read) this informations in akeeba ticket system from a specific category that i can do a category overview by myself?

-Count of Tickets (public) and Count of messages in tickets (public)
-title of latet ticket (including the date and name of user)

Best wishes
Mario

Monday, 06 January 2020 00:16 CST

nicholas

All tickets are in the #__ats_tickets table. All posts are in the #__ats_posts table. You can write your own SQL query to fetch the aggregate information you want. Please note that aggregate queries are slow – and please don't do a join, this makes things far far far far worse.

Regarding the latest ticket, first query #__ats_tickets table to get the information you want. Then query the #__ats_posts table for all ecords with the same ats_ticket_id and choose the one with the lowers ats_ticket_id to find the first post. The user_id is the Joomla user ID. You can pull up its record through JFactory to display the username.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Wednesday, 05 February 2020 17:17 CST

System Task

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Edited by on 2020-02-05 17:17 CST

Support