I am attempting to build a flashboard with the following criteria -
1.) Incidents that
are Resolved, Closed or Cancelled
2.) User defined Date range on a
Display Only form - Last Week or Last Month
3.) Only Incidents from
Helpdesk or Desktop Support
The issues I am having are with the
Date range for Last Month:
1.) If I search for 4/1 - 4/30, the
returned results bring back Incidents
from 5/1
2.) The Flashboard
brings back Incidents resolved from 3/23, due to we have
Incident
Rules to Auto Close in 10 days from the Resolved Status and AR
Escalator
is the one who modified this Incident
Anyone have a flashboard
with the similar Criteria? How have you overcome
this Last month
mayhem?
Is there a true Qualification to get the Last Month of
Incidents? I'm having
trouble finding the proper qualification. I
have also tested with
Resolved.TIME instead of Last Modified Date;
however the flashboard is blank
when I use this.
Here is the
current Customqual I have defined in the Active link to set the
criteria-
(((((((((((((((((("customqual='Status'
>=" + """") + "Resolved") + """") +
"AND 'Assigned Group' =") +
"""") + "HelpdeskSG") + """") + "OR 'Assigned
Group' =") + """") +
"DesktopSG") + """") + "AND 'Last Modified Date' >=") +
"""") +
$SDate2$) + """") + "AND 'Last Modified Date' <=") + """") +
$EDate2$)
+ """"
SDate2 and EDate2 are Date fields on the Display Only
with the Flashboards.
Any Help is appreciated.
Thanks in
advance,
Andre
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
