Jump to content

Giuseppe Iannacone

Hornbill Users
  • Posts

    481
  • Joined

  • Last visited

  • Days Won

    7

Posts posted by Giuseppe Iannacone

  1. 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?

  2. 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'

×
×
  • Create New...