Widget

[Giuseppe Iannacone]

Can you please provide me a dinamic sintax solution for a widget to get the data of quarter 3

I'm using this sintax, but has to be adjusted every year!

(h_status != 'status.cancelled' AND h_status != 'status.closed') AND  (h_requesttype = 'Incident' OR h_requesttype = 'Service Request' ) AND (h_datelogged>='19/07/01' AND h_datelogged<='19/10/01' ) AND h_fk_team_name = 'Infrastructure'

[Guest Chaz]

@Giuseppe Iannacone instead of explicitly typing the dates, you can define the current year in your query instead:

h_datelogged BETWEEN CONCAT(YEAR(CURDATE()),'-01-01') AND CONCAT(YEAR(CURDATE()),'-12-31')

 

[Giuseppe Iannacone]

1 hour ago, Chaz said:

@Giuseppe Iannacone instead of explicitly typing the dates, you can define the current year in your query instead:

h_datelogged BETWEEN CONCAT(YEAR(CURDATE()),'-01-01') AND CONCAT(YEAR(CURDATE()),'-12-31')

 

thank you Chaz, so for a specific quarter i may have '-07-01' and '-10-01' for quarter 3 for example, right?

[Guest Chaz]

@Giuseppe Iannacone that's correct