Q

Wants to create view selection formula for documents

Can you help a newbie? I am looking to create a view of documents that do not have Ref documents created for them. I wish to omit any document that has Ref documents. Can you help, either with code or else by directing me where to find the solution?
A view selection formula can only select documents for inclusion in a view based on the data in that document, or based on whether its parent is also in the same view. There's no way to select only documents that have no responses (or that have responses, or whose responses contain particular field values).

What you can do, however, is write a server agent that will scan for documents that meet your criteria and set a field value in those documents. The selection formula can use this field to decide whether to include them in the view. Or the agent can find these documents and put them into a folder. (Use the access properties of the folder to prevent users from manually adding and removing documents in the folder.)

I wrote an article for The View that explains how to create fancy views like this. If you're not a subscriber, you can still download the sample database.

Do you have comments on this Ask the Expert question and response? Let us know.

This was first published in August 2005

Dig deeper on Lotus Notes Domino Application Development

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchWinIT

Search400

  • iSeries tutorials

    Search400.com'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 ...

SearchEnterpriseLinux

SearchVirtualDataCentre.co.UK

Close