Hi all,
escaping $NULL$ with $\NULL$ did help. Now the where clause looks
like "...WHERE (T385.C810000221 IS NOT NULL)..." Everything o.k. now.
Thank you very much and kind regards,
Albert
J.T. Shyman schrieb:
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: arslist@ARSLIST.ORG
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: arslist@ARSLIST.ORG
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"
