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"
