Hi All & TGIF,
Have an interesting challenge that I am hoping to solve using the business time
function.
Currently when a ticket is created the number of the day is set in the 'Week'
field and the hour is set in the 'Hour' field. Also a filter checks a home
grown Holiday List table against the current date then it sets the "Holiday'
field to YES if it is a holiday. Of course if is not a Holiday then the
'Holiday' field is set to null.
Here is where it gets ugly. I have several notify escalations that use a
qualification similar to this one.
('Status' < "Closed") AND (('Create Date < ($TIMESTAMP$ - 3600)) AND ((
'Hour' >= 8) AND ( 'Hour' < 18)) AND (( 'Week' >= 2) AND ( 'Week' <= 6)) AND
(($TIMESTAMP$ - 'Create Date') > 3600) AND ( 'Holiday' = $NULL$ )
What I would like to get to is something like
('Status' < "Closed") AND (('Create Date < ($TIMESTAMP$ - 3600)) AND 'Work
Day' = "Yes"
Any ideas greatly appreciated.
Mark
____________________________________________
Mark Brittain
Remedy Developer
NaviSite
mbritt...@navisite.com<mailto:mbritt...@navisite.com>
(315) 453-2912 x5335 (Phone)
(315) 317.2897 (Cell)
________________________________
This e-mail is the property of NaviSite, Inc. It is intended only for the
person or entity to which it is addressed and may contain information that is
privileged, confidential, or otherwise protected from disclosure. Distribution
or copying of this e-mail, or the information contained herein, to anyone other
than the intended recipient is prohibited.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
