Merging view

Hi.. I would like to know the techniques in merging views from different databases into one view
khuloodaAsked:
Who is Participating?
 
Bozzie4Connect With a Mentor Commented:
If you have a servlet/jsp engine (for instance the Domino servlet engine (no jsp's there - but that's not essential), you should consider writing it in java.
This solution will perform better than anything you can write in agents (because the servlet remains in memory).

To sum it up:

1. servlet  to collect the data in the different views
2. agent to collect the data in the different views
3. link documents to gather all data in a view first.  Advantage here is that you can sort the results (because it's a regular view), and that the performance for the client will be reasonably good, and that is works in the Notes client too.

cheers,

Tom
0
 
madwaxCommented:
Can't you use:

SELECT * FROM db1.view1
JOIN db2.view2 ON db2.view2.attribute = db1.view1.attribute
ORDER BY otherAttribute

or something similiar?
0
 
khuloodaAuthor Commented:
thanks madwax;
but i guess it not possible to use the select statement in lotus, i heard that the merge can be done through XML... Any idea
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
khuloodaAuthor Commented:
thanks madwax;
but i guess it not possible to use the select statement in lotus, i heard that the merge can be done through XML... Any idea
0
 
madwaxCommented:
I don't know about Lotus but isn't there any custom function where you can use SQL-queries? I know for instance that you can do this in Access, even if they recommend one using the GUI with dropdowns and checkboxes...

Hope it works out though...
//jan
0
 
madheeswarCommented:
Thats impossible to do
0
 
madheeswarCommented:
madwax,
Lotus Notes is not SQL or Oracle or Access. And if you are not familiar with it, then its better not to answer.

Khulooda,
If you are talking about Notes client, then it is not possible at all.
if it is for web, then also I suspect whether it can be done or not. XML? let me explore it.
0
 
madheeswarCommented:
check these links;
http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/dd93856eaa05124285256c8b0077b919?OpenDocument

and this XML will be only useful in web.

If I can find a good link or code, I will post here.
0
 
khuloodaAuthor Commented:
madheeswar
 
Thanks for your help and if u found useful links please update me....
0
 
Bozzie4Commented:
There are 2 ways of doing this, although actually merging views is not possible.

1. create 'link' documents from the documents in 1 database to the other.  A link document will contain the document unique id of the actual document, the database where the actual document is, and all fields you want to use in your view (if you want to sort on name and title, you need to include these on your link document).  In the view, you will NOT open this link document, but instead the actual document.  This can be done by using a QueryOpen lotusscript

2. don't use a view at all, but use an agent to display the data.  If you let your agent output XML, then you can sort it on the browser side too.  Else, you will have rather static output.  The agent can get it's data from a (domain) full text search, or he can actually open the databases, and collect all documents from the views.

There are lots of variants you can think of, for these 2 solutions, and both solutions will actually kill performance :-)
But the 'link' documents solution is something we use quite often, mostly (but not exclusively) in web applications.  Then you can't use the QueryOpen event, of course, but it's very easy to manipulate the url link in the view.

cheers,

Tom
0
 
madheeswarCommented:
If I get this type of situation, I will tell the user to forget as it takes lot of time to implement and as Tom said, lot of performance issue.

Even for XML to work, u have to search and get the documents from both databases and display it using HTML.

The link provided is the same logic what I have told now.

best of LUCK.
0
 
khuloodaAuthor Commented:
madheeswar and Bozzie4
Thanks alot and for more information please let me know...
0
 
xp_commanderCommented:
"<a 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>
"

The author says "it's not a particularly efficient use of the server, but it works!' , the complete article can be found here :-
http://searchcrm.techtarget.com/tip/1,289483,sid4_gci489172,00.html?FromTaxonomy=%2Fpr%2F283836


In the newer version of Domino 6 and above , you can also use JSP for Domino. Here is a very good example on how to implement this :-

http://www.eview.com/eview/viewr5.nsf/e640f630a3361f84852568f600070fd3/561a071925475d7685256d4b006a6d7c?OpenDocument&Highlight=2,view,jsp

Hope this helps
0
 
RanjeetRainCommented:
khulooda,

It would be a nice thing to do. Can you describe your situation? WHy do you need it and most importantly what other things are going around your applicaiton.
0
 
khuloodaAuthor Commented:

My scenario is that am having many request applications in one database and i wana develop
for each request a seperate database and then display all the requests in one view
0
 
khuloodaAuthor Commented:

Can someone help if there are more ways :-)
0
 
khuloodaAuthor Commented:
Bozzie4, Thanks for your help and i will try it
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.