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.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.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"
