Widget not providing data

[Joyce]

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]

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]

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

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]

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

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

 

Thanks.

 

Joyce

[Victor]

@Joyce ah, ok I understand, thanks