APPLICATION DESIGN
When you design a view, you can program it to show all documents or only certain documents in the database. Most databases have one view that shows all documents and other views that show a subset of documents.
The default selection formula for new views combines the SELECT statement and the @All formula into SELECT @All, which means "include all database documents in this view." To narrow down the kinds of documents the view displays, add a program that displays only particular documents. For example, in a task-tracking database, the Work in Progress view could display only those documents whose Status field does not contain "Complete." In a brainstorming database, the Design Ideas view could display all documents categorized as "Design Suggestion." Here is a selection formula that displays only documents containing new features and displays them in a What's New view:
SELECT @IsMember("01 What's new?"; View)
Choosing the type of view selection
With a view you program the document selection in the Programmer's pane. Choose "View Selection" in the Objects box, select the type of programming you want to add, and build the program in the View Selection pane.
Simple Search
Simple Search allows you to create a conditional document selection without knowing a programming language. In the InfoList of the Programmer's pane, click the Run list box and select Simple Search. Then click "Add Condition" for each selection you want to include. To delete a condition, click it and choose Edit - Delete.
By Formula
By Formula allows you to create a program for selecting documents using the @function formula language. In the Programmer's pane, click By Formula and write the formula in the Script area.
Example See Also