Joyce Posted May 31, 2018 Share Posted May 31, 2018 Hi, I had created widgets to display tickets which are about to breach in 2 days' time. I had both the list of tickets , and count of ticket. This was working perfectly until today, where no value is displayed, but we do have tickets which are about to breach. This is the sql I have for the list of SR: SELECT h_pk_reference as "Reference" , h_summary, h_ownername as "Owner", h_fixby as "Resolve By" FROM h_itsm_requests WHERE h_requesttype = 'service request' AND DATE(h_fixby) BETWEEN DATE (CURDATE()) AND (CURDATE() +2) AND h_fk_team_name ='Application Support' AND (h_status = "status.new" OR h_status = "status.open") And this is the query for count: this brings 0 data, while when looking at the application, there values due to breach in two days time Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now