I have a search being performed by a user that is returning unexpected results,
and I was hoping someone may know why. I have a theory, but would like to see
what the experts in the community think.
Below is a modified version of the search being performed:
('Assigned Group*+' = "Group 1" OR 'Assigned Group*+' = "Group 2" OR 'Assigned
Group*+' = "Group 3") AND ( 'Assignee+' != "Jane Doe") AND ( 'Submit Date'
>= "$Start Date$" AND 'Submit Date' < "$End Date$" ) AND ('Status*' !=
"Cancelled")
This search is returning the expected results on tickets assigned to
individuals, but does not return results for tickets that have not yet been
assigned. Any insight would be great. I am mainly just curious why NULL
fields are not included in the search.
Thanks in advance for any feedback.
ARS 7.5
ITSM 7.6 0
SQL 2005
Server 2008 (64-bit)
Thanks,
Shane Buchholz
Systems Analyst II - Remedy
Information Services Operations
Samaritan Health Services
________________________________
Confidentiality Notice: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
