02
Sat, Nov
2 New Articles

A Look at Notes/Domino Views

Collaboration & Messaging
Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

The basic element of a Lotus Domino application is a document. It is used to store data. One step farther away from the data is the form. The form’s purpose is data entry and document display. One step farther is a view. A view is a list of documents from a Domino database. This list can be sorted and categorized using one or more key values. Lotus defines a view as the entry point to the data stored in a Domino database, and I can think of no better definition.

Figure 1 shows a basic sample view displaying only two documents. The documents are listed using a field value, and the view is sorted alphabetically. The user clicks the mouse twice to open and view the contents of the document. The view in Figure 1, unfortunately, is not very user-friendly. I am sure you could think of numerous ways to improve its appearance. In this article, I will introduce the many facets of a view, working toward the goal of designing your own view. A view can be as simple or complex as desired. There are many features at the developer’s fingertips, and here I’ll take a look at some of them.

There are two view styles: calendar and standard outline. Figure 1 displays a basic outline view named Attachments. As you can see, this view contains one column and two documents. The documents are listed from top to bottom with possible categorization and sorting. A calendar view displays documents in the form of a grid. This can show two days, one week, two weeks, or a month at a time. In this article, I’ll cover standard outline views—calendar views will not be covered.

There are two types of views, one with slight variations. A private view is for use only by the creator. For instance, I may create one or more private views in my mail file for viewing my mail in a nonstandard format. The other type of view is shared. In theory, everyone can view a shared or public view. More realistic is the possibility that security will be placed on the view, so that it will be viewable only by a defined group of people within an organization. There are a few variations of the shared view, but I won’t cover them in this article.


Style

Type

Selecting Documents

Another powerful aspect of a view is the flexibility afforded to what is actually displayed in it. Each view contains a selection formula that defines what is displayed. The default selection is all documents from the database. Here is the default selection formula:

Select @All

Notice the default formula takes advantage of the Notes @formula language. Document attributes can be used in the selection formula. For example, the next formula selects only those documents created with the Midrange form.

Select (FORM = Midrange)

This could be rewritten with an @formula:

Select (@Contains(FORM, “Midrange”))

Boolean comparisons can be utilized in the selection formula as well. The ampersand (&) is used for logical AND and the pipe (|) represents logical OR. These can be combined with parentheses. Here is a selection formula that displays all documents created with the Midrange or Computing forms, where the name field contains the value Tony. I always use parentheses to guarantee a formula is evaluated in the order expected:

Select (((FORM=”Midrange”) | (FORM=”Computing”)) & (@Contains(name,”Tony”)))

Selection formulae cannot be dynamic—that is, values used in the formula must be known at design time. So, certain @formulae such as @DbLlookup are not permitted. In addition, the use of date-time @formulae is strongly discouraged. The system clock is always ticking, so the contents will always be in flux.

Take a look at the actual placement of data in a view. I have always thought of a view as a variation of a spreadsheet: Both have rows and columns, with data residing in the intersection (cell) of the two. A Domino view can have one or more columns. The number of columns is limited to screen real width.

A column displays one type of information pertaining to the listed document or documents. This can be as simple as the creation date or a field value. The column value can be a data value from the document, an @formula, or a combination of the two. As with selection formulae, certain @formulae are not permitted such as @DbLookup.

Creating a View

The creation of a view in the Domino Designer product is simple. Open your database in design mode, select Views, and use the New View button to create a new view. You can use the Create drop-down menu as well. Figure 2 shows the dialog box that is opened once a new view is created. The dialog box facilitates the assignment of a name; select the type of view from the drop-down list; select where the view appears in the context of other views in the database; enter a selection formula; and, optionally, use another view as a template for your new view.

I enter Midrange for the view title. This is a shared view, and I use the defaults for the rest. I click the OK button, which places the view in the list of views in the database. Double-click on the view to open it in design mode.

Selecting the column accesses a column’s data value. In addition, column attributes like color and font are selected by double-clicking the column. Figure 3 displays the design


Columns

I assigned to the first column in the view. As you can see, I use a combination of a field value and @formulae for the column value. Additional columns can be added by right- clicking and selecting Insert new column from the pop-up menu, selecting Insert new column from the Create drop-down menu, or by double-clicking to the right of the last column in the view.

Double-clicking on a column header opens its property box. Figure 4 shows the properties box for the column, commonly referred to as an infobox. This box allows the developer to set the column display title, font, and spacing, for example. Open the infobox to the second tab. This allows a column to be designated as sorted or categorized. As you can see in Figure 4, the column is sorted in ascending order.

Hierarchy

Views can also contain a hierarchy. This means that documents can appear as children under other documents or a category. Response is a type of document that is specially linked to a parent document. This relationship can be properly displayed in a view and is designated in the view property infobox (similar to that in Figure 4). The view name is designated as well, so it can be easily changed. Also, colors and fonts for rows, column totals, and unread documents can be set.

Folders are similar to a view. Both use columns and rows to display documents contained within them. Folders are also convenient because you can drag documents to them and double-click the folders to see their contents. As a Domino developer, a folder is designed in the same manner as a view. A folder has columns, rows, and selection formulae. A document can appear in multiple views but in only one folder.

I hope this article has given you a clear idea of views, how they are used, and where they live and breathe in the world of Domino. A view is one of the most important and powerful components of Domino. Combine it with robust Domino security, and a view becomes a powerful design element for presenting the right data to the right people at the right time.

Figure 1: A simple outline view shows possible categorization and sorting.


Folders

A_Look_at_Notes-_Domino_Views03-00.png 444x315

A_Look_at_Notes-_Domino_Views04-00.png 445x397

Figure 2: A dialog box is presented when you create a view.

Figure 3: Here, data is being defined for the first column of the view.


A_Look_at_Notes-_Domino_Views04-01.png 445x376

A_Look_at_Notes-_Domino_Views05-00.png 575x430

Figure 4: The properties dialog of a view column is used to define column attributes and column function.


BLOG COMMENTS POWERED BY DISQUS

LATEST COMMENTS

Support MC Press Online

$

Book Reviews

Resource Center

  • SB Profound WC 5536 Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application. You can find Part 1 here. In Part 2 of our free Node.js Webinar Series, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Brian will briefly discuss the different tools available, and demonstrate his preferred setup for Node development on IBM i or any platform. Attend this webinar to learn:

  • SB Profound WP 5539More than ever, there is a demand for IT to deliver innovation. Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects. The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.

  • SB HelpSystems ROBOT Generic IBM announced the E1080 servers using the latest Power10 processor in September 2021. The most powerful processor from IBM to date, Power10 is designed to handle the demands of doing business in today’s high-tech atmosphere, including running cloud applications, supporting big data, and managing AI workloads. But what does Power10 mean for your data center? In this recorded webinar, IBMers Dan Sundt and Dylan Boday join IBM Power Champion Tom Huntington for a discussion on why Power10 technology is the right strategic investment if you run IBM i, AIX, or Linux. In this action-packed hour, Tom will share trends from the IBM i and AIX user communities while Dan and Dylan dive into the tech specs for key hardware, including:

  • Magic MarkTRY the one package that solves all your document design and printing challenges on all your platforms. Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Make sure your data survives when catastrophe hits. Request your trial now!  Request Now.

  • SB HelpSystems ROBOT GenericForms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.

  • SB HelpSystems ROBOT GenericIT security is a top priority for businesses around the world, but most IBM i pros don’t know where to begin—and most cybersecurity experts don’t know IBM i. In this session, Robin Tatam explores the business impact of lax IBM i security, the top vulnerabilities putting IBM i at risk, and the steps you can take to protect your organization. If you’re looking to avoid unexpected downtime or corrupted data, you don’t want to miss this session.

  • SB HelpSystems ROBOT GenericCan you trust all of your users all of the time? A typical end user receives 16 malicious emails each month, but only 17 percent of these phishing campaigns are reported to IT. Once an attack is underway, most organizations won’t discover the breach until six months later. A staggering amount of damage can occur in that time. Despite these risks, 93 percent of organizations are leaving their IBM i systems vulnerable to cybercrime. In this on-demand webinar, IBM i security experts Robin Tatam and Sandi Moore will reveal:

  • FORTRA Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:

  • FORTRAManaging messages on your IBM i can be more than a full-time job if you have to do it manually. Messages need a response and resources must be monitored—often over multiple systems and across platforms. How can you be sure you won’t miss important system events? Automate your message center with the Robot Message Management Solution. Key features include:

  • FORTRAThe thought of printing, distributing, and storing iSeries reports manually may reduce you to tears. Paper and labor costs associated with report generation can spiral out of control. Mountains of paper threaten to swamp your files. Robot automates report bursting, distribution, bundling, and archiving, and offers secure, selective online report viewing. Manage your reports with the Robot Report Management Solution. Key features include:

  • FORTRAFor over 30 years, Robot has been a leader in systems management for IBM i. With batch job creation and scheduling at its core, the Robot Job Scheduling Solution reduces the opportunity for human error and helps you maintain service levels, automating even the biggest, most complex runbooks. Manage your job schedule with the Robot Job Scheduling Solution. Key features include:

  • LANSA Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.

  • LANSAWhen it comes to creating your business applications, there are hundreds of coding platforms and programming languages to choose from. These options range from very complex traditional programming languages to Low-Code platforms where sometimes no traditional coding experience is needed. Download our whitepaper, The Power of Writing Code in a Low-Code Solution, and:

  • LANSASupply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals. In this webinar, we discuss how:

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • Profound Logic Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn: