Joyce Posted May 31, 2018 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
Joyce Posted May 31, 2018 Author Posted May 31, 2018 4 hours ago, Joyce said: 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
Victor Posted June 1, 2018 Posted June 1, 2018 @Joyce I need to look at the data in your instance. If that's ok, can you please PM the admin account credentials? I also moved this thread to "Advanced Analytics" section.
Joyce Posted June 5, 2018 Author Posted June 5, 2018 Hi Victor, Managed to get the data I wanted finally. I had to put date interval, as noticed, it was only giving data upto end of the month. This query can be closed now. Thanks. Regards, Joyce
Victor Posted June 5, 2018 Posted June 5, 2018 @Joyce happy to hear you managed to sort it 10 minutes ago, Joyce said: I had to put date interval, as noticed, it was only giving data upto end of the month I don't quite understand this, may I ask for some details? Sorry, been a long week already for me (I know is only Tue...)
Joyce Posted June 12, 2018 Author Posted June 12, 2018 Just changed my resolved date interval to : DATE(h_fixby) BETWEEN DATE(NOW()) AND DATE(NOW() +INTERVAL 2 DAY) and it worked. Thanks. Joyce
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now