| condition not working [message #313087] |
Thu, 10 April 2008 11:39  |
aarti81
Messages: 235
Registered: December 2007
Location: USA
|
Senior Member |
|
|
Hi all
I added a new condition............................
"STATUSCODE=12 AND STATUSCODE!=13"
Where STATUSCOD -----13 IS ARCHIVED RECORD
Its not showing any of the archive records except for one................i dont know why, any ideas?
Thanks
|
|
|
|
|
|
| Re: condition not working [message #313330 is a reply to message #313196] |
Fri, 11 April 2008 07:06  |
aarti81
Messages: 235
Registered: December 2007
Location: USA
|
Senior Member |
|
|
| skooman wrote on Fri, 11 April 2008 01:13 | You did add this condition in Discoverer you mean? If so, I wasn't aware of the possibility to use the syntax != in the front end. Can you try what happens if you use <>?
Other option: can there be null values involved? If so, be aware that null values are not equal to anything but also not not equal to anything... (always a lovely exercise to try to understand this  )
|
Thank You
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
