Yes. For some reason, table fields handle enum values very peculiarly. Try the != "" and see if that works..
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 J.T. Shyman Sent: Monday, December 03, 2007 12:42 PM To: [email protected] Subject: Re: Trouble with external table qualification using != $NULL$ on enum field Technically speaking "" and NULL are not the same thing. NULL indicates a field isn't set at all, "" indicates the field is empty. Also, isn't the escape to tell Remedy that you are using a keyword the other slash? i.e. $\NULL$ J.T. Shyman Column Technologies Cell: 404-242-5407 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, December 03, 2007 1:39 PM To: [email protected] Subject: Re: Trouble with external table qualification using != $NULL$ on enum field .. and 'enumval' != "" > Have you tried using $/NULL$ > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Albert Bihler > Sent: Monday, December 03, 2007 12:27 PM > To: [email protected] > Subject: Trouble with external table qualification using != $NULL$ on enum > field > > Hi list, > > I am currently a bit stunned how ARS / Oracle try > to do searches on enum filds that check for != $NULL$ > > On a tabel field that uses an external qualification > as "'enumflag' = 0". I can see in sql log something > like "... where (T385.C536870961 = 0)...". > > If I try this using "'enumflag' != $NULL$" I don't > get the result that I would expect. in sql log I > see that the whole where-clause of the statement > turns to "WHERE (1 = 0)". That obviously doesn't > return many matches. I played a bit around wiht > "NOT 'enumflag' = 0" but this results also in > "WHERE (1 = 0)". > > If I try the same searching on an ARS integer field > everything seems to work fine. Now I could write > workflow that always updates the integer field with > the value of the enum field and run the searches > against the integer field. But this seems quite > a lot of overhead and waste of database space > for a simple table qualification. > > Any ideas are greatly appreciated. > > ARS 7.0.1 > Solaris 10 > Oracle 10g > > Kind regards, > Albert > > ________________________________________________________________________ ____ ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ________________________________________________________________________ ____ ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ________________________________________________________________________ ____ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
