Generating dynamic Web reports

Generating dynamic Web reports

Tip submitted by
Subhash Kothari

Level: Intermediate
Works with: Notes/Domino
Updated: 01-Apr-2003

This tip describes how to generate dynamic Web reports or a list of documents without creating a view. It uses the ?SearchView&Query URL command. To use this tip, you must know the view name and the field names in the form from which you want to generate the report or list of documents. Note that this tip works only in Web browsers.

Here is the basic syntax for generating the Web report:

http://servername/database.nsf/viewname?SearchView&Query=(FIELD+Fieldname+=+Fieldvalue)

You must supply the server name, database file name, view name, field name, and the value of the field to build the report. For instance, you can generate a report of documents by a certain author.

In addition, you can add more fields to narrow down the report further using this syntax:

http://servername/database.nsf/viewname?SearchView&Query=(FIELD+Fieldname+=+Fieldvalue)+AND+(FIELD+Fieldname+=+Fieldvalue)

You can add as many fields as you like to the URL.

Here are example URLs from LDD Today. In the first example, we specify an author name to retrieve a list of articles by that author. Click the URL to see a list of articles by this author:

http://www.lotus.com/ldd/today.nsf/Date?SearchView&Query=(FIELD+Authoredby+=+Tara%20Hall)

In this example, we specify author name and a date. Click the URL to see a list of articles by this author in a specified month:

http://www-10.lotus.com/ldd/today.nsf/Date?SearchView&Query=(FIELD+Authoredby+=+Tara%20Hall)+AND+(FIELD+PubDate+=+03/03/2003)

Using a search query to generate Web reports can reduce the need for multiple views. It also saves you from having to create a number of personal views.

SUBMIT YOUR TIPS!

We encourage you to send us your tips (You can also click the "Would you like to submit a tip?" graphic below.) Your tips can be anything you've discovered about any Lotus product. The most important thing is that your tip be interesting, useful, or handy. And be sure to include complete information about how your tip works. For ideas, take a look at our tip archives. If we publish your tip, we'll send you the IBM Redbooks Lotus Collection on CD.