Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Web Help Desk (WHD) > Unable to search tickets by Due Date or First Call Resolution

Unable to search tickets by Due Date or First Call Resolution

 

Overview

When you perform an advanced search using Due Date or First Call Resolution as condition qualifiers, the search does not produce any results. 

Environment

  • WHD 12.5 configured with a non-embedded, non-default MySQL™ database

Cause 

The following system tables in your MySQL database are not populated with data:

  • time_zone
  • time_zone_name
  • time_zone_transition
  • time_zone_transition_type

These tables exist when you install MySQL in your deployment, but are not populated by default with data. Web Help Desk requires this data because Due Date and First Call Resolution qualifier logic is implemented from within the database. If the database is missing time zone data, these qualifiers will not work properly.

Resolution

Manually populate the system tables with data using the attached SQL file. See the MySQL website and follow the instructions for MySQL Server time zone support. 

 

 

 

Last modified
09:49, 7 Nov 2016

Tags

This page has no custom tags.

Classifications

Public