Home » Developer & Programmer » Reports & Discoverer » condition not working (disc 10.1.2)
condition not working [message #313087] Thu, 10 April 2008 11:39 Go to next message
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 #313196 is a reply to message #313087] Fri, 11 April 2008 01:13 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
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 Wink)
Re: condition not working [message #313330 is a reply to message #313196] Fri, 11 April 2008 07:06 Go to previous message
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 Wink)

Thank You
Previous Topic: "No data found" message / parameter drop down list
Next Topic: calendar in date parameter
Goto Forum:
  


Current Time: Thu Dec 08 20:14:07 CST 2016

Total time taken to generate the page: 0.10465 seconds