Help required on View Selection formula

[Database Administrator]

Hi ,

I need to display a view, which selects a documents from two different
datases.

can i do this by using a view selection formula ??? please sujjest an
alternative to accomplish this..


thanks

[Database Administrator]

"ume.lotus@gmail.com" wrote in message
news:cc5374a7-54cc-4d63-8372-ef49d4e3f83a@x35g2000hsb.googlegroups.com...
> Hi ,
>
> I need to display a view, which selects a documents from two different
> datases.
>
> can i do this by using a view selection formula ??? please sujjest an
> alternative to accomplish this..

No, you can not do that in a view. A view will only show documents in
the current database[1].

What you can do is to create an agent. This agent will collect the
documents from both databases.
The agent then create a NotesDocument with a RichText field.
You have also previously created a "template" form containing one single
row of what you want to display in the "view" (table), with one field
for each value ("column"). I usually build this using a one-row table,
so you get a nice layout.
The next step is to loop through all documents you collected. For each
document, retrieve the data, create a new document beased on the
template form, populate the fields with your values and use
RenderToRTItem() to rended the template document into the rich text
field in the NotesDocument you created in the beginning.
When you have looped through all the documents, you have a back-end
document you can open in the UI to the user, and they will see the data
from two databases presented in a nice way.

You can see an example using this technique here:
http://www.flickr.com/photos/texasswede/2235410624/
Each box/section is a separate document, retrieved from another
database.

/Karl

[1] Exception: if you are using LEI or DB2 views, I believe you can
combine several database sources into one view.

--
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?
=============
Visit my blog at http://www.bleedyellow.com/blogs/texasswede/