• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 467
  • Last Modified:

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

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,

  • 2
1 Solution
scriblaAuthor Commented:
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?
Sjef BosmanGroupware ConsultantCommented:
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!=""
scriblaAuthor Commented:
Thanks sjef, by populated I mean the opposite of Null. Thanks for the code examples.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now