/build/static/layout/Breadcrumb_cap_w.png

Filter Report Based On 2 Timestamp Criteria

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

0 Comments   [ + ] Show comments

Answers (1)

Posted by: chrisgrim 13 years ago
Senior Purple Belt
0
kaneda0149,

We have a similar report example posted in the FAQs which should get you where you need to go:

http://www.kace.com/support/kb/index.php?action=artikel&cat=8&id=652&artlang=en

Chris...
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ