Jump to content

Recommended Posts

Posted

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:

image.png.6cd786f2a6652c484fdf5e8ac2c4a448.png

 

this brings 0 data, while when looking at the application, there values due to breach in two days time

Posted
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:

image.png.6cd786f2a6652c484fdf5e8ac2c4a448.png

 

this brings 0 data, while when looking at the application, there values due to breach in two days time

 

Posted

@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.

Posted

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

Posted

@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...)

Posted

Just changed my resolved date interval to :  DATE(h_fixby) BETWEEN DATE(NOW()) AND DATE(NOW() +INTERVAL 2 DAY)  and it worked. 

 

Thanks.

 

Joyce

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

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...