Manage Learn to apply best practices and optimize your operations.

Multiple Views From Multiple Databases On One Page

By
  • Dave Kinder
Published: 01 Nov 2000
I wanted to show an html page on our secure extranet site of all changed
documents in the last week. The documents reside in a number of different
databases.

I made a view in each of the source databases of documents changed in the last
seven days using @adjust.

I Created a computed for display text field, allowing multi-values, for each
database using @DbColumn on each view.

In the code below, column 4 of "YourView" contains an @Text(@DocumentUniqueID)
so that we can get an html link to the document.

I imagine it's not a particularly efficient use of the server, but it works!

Dave
"&LTa href=http://" + HTTP_Host +"/YourDatabase.nsf/YourView/" +
@DbColumn("":"No Cache";"YourDatabase.nsf";"YourView";4) +
"?OpenDocument>" +
@DbColumn("":"No Cache";"YourDatabase";"YourView";2) +
" - " +
@DbColumn("":"No Cache";"YourDatabase";"YourView";3) +
"</a>
"

Dig Deeper on Lotus Notes Domino Administration Tools

Start the conversation

Send me notifications when other members comment.

Register

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

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 ...

SearchDataCenter

SearchContentManagement

Close