WordPress.org

Ready to get started?Download WordPress

Forums

FireStorm Support Ticket System
[resolved] Query Number of Unread Tickets (2 posts)

  1. askwpcoach
    Member
    Posted 1 year 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 1 year 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';

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags