Hi All!
Can i create a view, that displays documents from 2 databases?
How can i do it?
Thanks!
Bye
Alexander
Subject: One View - 2 Databases
HiI’m quite certain that you can not display documents from other databases than the one that the view is in; you can though display views from other databases. And therefore you can not mix documents from 2 databases (I think).
Best regards
Olle
Subject: RE: One View - 2 Databases
Is this Notes client or Web Browser?
If its a web browser then you can write an agent that reads two separate databases and then creates a “view” using HTML.
If its notes then the only solution I’m aware of would be copy all the documents from both views into another database and view them there…not very dynamic though.
Also for notes clients: You could use a Java Applet attached to a page or form that reads both views and creates another “view”…this one is a probably over-kill though
Regards,
Andy.
Subject: RE: One View - 2 Databases
well just as on the web where you could write an agent… you could write an agent in the client that generates a report rather than a view…
The report could have a dynamic table that shows all the info in rows and columns just like a view…
You would just have to create a collection documents from both dbs and then write the data to a richtext field in a table…
I beleive I saw an article in the view or the advisor that did something like that…
Wouldn’t be too difficult, I don’t think. Just have an action button called “Generate Report” or something…
It could read the data from both dbs and write it to a new doc that you don’t save… So always current whenever clicked… Like a snap shot…