View selection formula - do not display docs if field is null.

Posted on 2005-04-15
Medium Priority
Last Modified: 2013-12-18
Can anyone give me an example view selection formula that will only return documents if a field is populated?
I am unable to do this using 'simple search' functions.
Field name is JobNumber.

Thanks Guys,

Question by:scribla
  • 2

Author Comment

ID: 13788995
I ended up with this:

SELECT (@If(@IsNull(JobNumber)=0;1;0))

Works fine.

Points to anyone who'd care to comment, maybe the above forumla is not very efficient? is there a better way?
LVL 46

Accepted Solution

Sjef Bosman earned 1200 total points
ID: 13789363
About your formula, the following might be equivalent:
    Select !@IsNull(JobNumber)

But what do you mean with populated? If the field exists, but its content is "", is it then populated? Otherwise, the following formula should do
    Select JobNumber!=""

Author Comment

ID: 13789389
Thanks sjef, by populated I mean the opposite of Null. Thanks for the code examples.

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month15 days, 1 hour left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question