ITNinja

Hi,
I'm trying to create a report where it filters based on 2 parameters;
1. Status = Approved
2. Time Closed < 11:00 am each day or Time Closed >= 11:00 am and < 3:00 pm each day

Not sure if this type of parameter is even possible, looked at the options available in the wizard and there was nothing there that quite fit my need. Purpose is to capture all requests Approved within those 2 timeframe so the report does not display the same items. Still a newbie in MYSQL, so the help would be great!


SELECT HD_TICKET.TITLE AS TITLE, HD_PRIORITY.NAME AS PPORT, HD_TICKET.CUSTOM_FIELD_VALUE0 AS ACCTNUM, HD_TICKET.CUSTOM_FIELD_VALUE1 AS PAYEEID, HD_TICKET.CUSTOM_FIELD_VALUE2 AS PAYEENAME, HD_TICKET.CUSTOM_FIELD_VALUE3 AS PAYEEADDR1, HD_TICKET.CUSTOM_FIELD_VALUE4 AS PAYEEADDR2, HD_TICKET.CUSTOM_FIELD_VALUE5 AS PAYEEADDR3, HD_TICKET.CUSTOM_FIELD_VALUE6 AS PAYEEZIP, HD_TICKET.CUSTOM_FIELD_VALUE7 AS AMOUNT, HD_TICKET.CUSTOM_FIELD_VALUE9 AS BENID, HD_TICKET.CUSTOM_FIELD_VALUE10 AS BENNAME, HD_TICKET.CUSTOM_FIELD_VALUE11 AS BENADDR, HD_TICKET.CUSTOM_FIELD_VALUE12 AS BENZIP, HD_TICKET.CUSTOM_FIELD_VALUE13 AS MESSAGE, HD_TICKET.CUSTOM_FIELD_VALUE14 AS PCODE FROM HD_TICKET JOIN HD_PRIORITY ON (HD_PRIORITY.ID = HD_TICKET.HD_PRIORITY_ID) WHERE (HD_TICKET.HD_QUEUE_ID = 8) AND ( (1 in (select 1 from HD_STATUS where HD_STATUS.ID = HD_TICKET.HD_STATUS_ID and HD_STATUS.NAME = 'Approved')) ) ORDER BY HD_TICKET.TITLE asc


Asked 14 years ago 1781 views