Odd Search Behavior
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
Re: Odd Search Behavior
Hi Shane,
Doug gave an explanation no to long ago. You can view it here:
http://old.nabble.com/Re%3A-Question-about-NULL-p31147507.html
Jason
On Thu, May 12, 2011 at 8:51 AM, Shane Buchholz sha...@samhealth.orgwrote:
**
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.
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Odd Search Behavior
Thanks Jason, that is exactly what I thought it was doing. When we added
'Assigned Group+' = $NULL$ during testing it worked like we wanted it to.
Thanks,
Shane Buchholz
Systems Analyst II - Remedy
Information Services Operations
Samaritan Health Services
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Thursday, May 12, 2011 9:05 AM
To: arslist@ARSLIST.ORG
Subject: Re: Odd Search Behavior
** Hi Shane,
Doug gave an explanation no to long ago. You can view it here:
http://old.nabble.com/Re%3A-Question-about-NULL-p31147507.html
Jason
On Thu, May 12, 2011 at 8:51 AM, Shane Buchholz
sha...@samhealth.orgmailto:sha...@samhealth.org wrote:
**
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.
_attend WWRUG11 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers
Are_
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
