WordPress.org

1. askwpcoach
   Member
   Posted 7 months ago #
   

   Hello,

   I'm creating a custom admin theme, and I would like to show the number of unread tickets on the dashboard.

   Please let me know what query to use, to retrieve the number of unread tickets.

   Thanks

   http://wordpress.org/extend/plugins/fs-tickets/

2. FireStorm Plugins
   Member
   Plugin Author
   Posted 6 months ago #
   

   Hello,

   The following SQL command will return the number of unread tickets:

   SELECT COUNT(ticket_status) FROM wp_fst_tickets WHERE ticket_status = 'pending';

Reply

You must log in to post.