I wasn't aware that it did this, either, but there is a very significant difference between...
!= '' And... IS NOT NULL In terms of databases. I would think if the Midtier is doing this, it's a problem. Norm -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Friday, September 07, 2007 3:00 PM To: [email protected] Subject: Re: 6.3 Mid Tier Search Question I can't explain this, but have run into things similar to this before. You can try != "" instead of != $NULL$ in the mid-tier and see if that works. It may not, as what you are seeing is a little different than what I've seen before. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: Friday, September 07, 2007 2:57 PM To: [email protected] Subject: 6.3 Mid Tier Search Question Listers, I implore your help once again!!! We just setup Mid Tier, so please forgive what may be a silly question. Once of the things that we found (but can't explain), is that it seems that the $NULL$ keyword works differently. For instance, while running a search with the NULL keyword in a particular field (specifically, "!=$NULL$"), there were 0 results returned. When we did the same in the User Client, or used the Advanced Search (for both User & Mid Tier), then we received 277 results. After investigating the logs, we found that by using the Fields on Mid Tier, the SQL did: " Table.Field != '' " Using the same logs, and running the search by Advanced Search or the User client, we found that the SQL did: " Table.Field IS NOT NULL " Is there a reason for this that anyone is aware of? Is there a way to make it "behave" itself (sorry, bad pun)? HUGE thx in advance!!!! Shawn Stonequist EMNS Inc. Remedy/MidTier 6.3 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
