Displaying documents from different databases in a single view
I have several databases (db vendorA, db vendorB, db vendorC and so on). The documents within these databases have category field with several values assigned (shoes, caps, jackets and so on)
When a web user picks specific category, I need to select documents based on the chosen category in all the databases and display them on the web, in a single view - for example, all documents that have category "shoes" from all the vendors
I would prefer to keep databases separate.
I am considering to run an agent that would build collection of the documents, but not sure how much load it would bring to the server
When a web user picks specific category, I need to select documents based on the chosen category in all the databases and display them on the web, in a single view - for example, all documents that have category "shoes" from all the vendors
I would prefer to keep databases separate.
I am considering to run an agent that would build collection of the documents, but not sure how much load it would bring to the server
Those separate views would be each in its own database and then simply called by outline entry.
Another idea, you could use a page or form in your database, containing an embedded view. That view that's embedded may reside in another database.
Another idea, you could use a page or form in your database, containing an embedded view. That view that's embedded may reside in another database.
ASKER
Domino version is 8.5
DB2 query would require DB2 Access server
I could create separate view for each db and switch between them but it would not solve the problem
For example, let's say first DB is "Reebok", second DB is "Nike", another one is "Adidas" and so on.
what is needed that when user picks category, for example "sneakers", the site should display sneakers from all the vendors from different databases
DB2 query would require DB2 Access server
I could create separate view for each db and switch between them but it would not solve the problem
For example, let's say first DB is "Reebok", second DB is "Nike", another one is "Adidas" and so on.
what is needed that when user picks category, for example "sneakers", the site should display sneakers from all the vendors from different databases
There's no way you can do that, in a way you want, without DB2-enabling your Domino server.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, guys
Domgle seems to hit the spot... and it is time to learn XPages
Domgle seems to hit the spot... and it is time to learn XPages
The only way you can show documents from multiple databases in a single view is by using DB2 query view design element in Domino DB2 enabled databases, which became available in v7:
http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/topic/com.ibm.designer.domino.main.doc/H_DB2_QUERY_VIEWS_1555_OVER.html
But why wouldn't you create separate view for each db (category) and then simply switch between views?