View Selection Formula Trick

How often in a view have you coded a selection formula to select all documents by form where the form name is not equal to A or B ? You'd normally write this as :

SELECT Form<>"Form A" & Form<>"Form B"

Did you know there is a shorter way of writing this ? I discovered this by accident. Instead of the above use this :

SELECT !Form="Form A":"Form B"

This type of comparison will work anywhere, it's not limited to view selection formulas.

This was first published in November 2000

Dig deeper on Domino Resources - Part 7



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...