	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.7

Get values from view entries

Asked by shuboarder in Lotus Notes, Lotus Domino Email Server

Tags: Lotus Notes, lotusscript

Hi,

I've got an idea that I am struggling to develop.
We have a self developed database catalog that has information on each of our databases.
We have 5 fields in our database documents where we can add "related databases" i.e. dbs we link to etc.

What I would like to do is create a portal type of linking system so that from within any of our databases we can link to the related databases based on our catalog information.

So far I have come up with the idea of creating a view in our catalog that displays database name in first column and related databases in second column.

i.e.

Database Name Related Databases
HR Database
HR News
HR Statistics

etc.

I would then like to embed this view into a page in any database showing single category based on current database name (@dbname)

So far so good...

Now the tricky part!

I would like it so that whenever someone clicks one of these documents in the embedded outline it takes them to that database and not the document in our catalog.

In the example above in our HR Database users would see the page with the embedded view and the 2 related databases. If they click the line that says HR News, then the HR News database will open etc.

The code below is a mess and will not work I know, but hopelly it will sort of give an idea of what I am trying to do.

I'm open to suggestions on better ways of achieving this etc. and appreciate any help you can provide.

Get your answer NOW

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:

           
           
             Sub Queryopendocument(Source As Notesuiview, Continue As Variant)
	Dim sess As New NotesSession	
	Dim ws As NotesUIWorkspace
	Dim db As NotesDatabase
	Dim CurrentServer As String
	Dim doc As Notesdocument
	Dim folder As String
	Dim dbname As String
	
	Dim uidoc As NotesDocument
	Dim uiview As NotesUIView
	
	Continue = False ' Don't open the document
	
	Set ws = New NotesUIWorkspace
	Set db = sess.CurrentDatabase
	
	' Need to now get the selected view entry, take whatever is displayed in column 2 and then perform a lookup on this value
	' When we find the database in our catalog we can open by replicaID or folder / filepath
	
	folder = uidoc.FieldGetText("Folder")
	dbname = uidoc.FieldGetText("DatabaseName")
	
	CurrentServer = db.Server
	
	Call ws.OpenDatabase(CurrentServer, folder & "/" & dbname)
End Sub

           
         

20091111-EE-VQP-89 - Hierarchy / EE_QW_3_20080625

Hall of Fame

1. sjef_bos...506,454
2. SysExpert172,873
3. Bill-Hanson171,555
4. mbonaci122,855
5. brwwiggins48,793
6. fgrushev...40,685
7. akhafaf37,470
8. madhees...24,814
9. LotusDave24,155
10. daj_uk23,351
11. CRAK20,940
12. GregBussey19,237
13. mekhet3016,495
14. doninja14,014
15. qwaletee13,750
16. madgino12,350
17. cezarF12,332
18. sreeser9,000
19. Blackmoo...8,808
20. tomsparrow8,575
21. kcarrim8,500
22. lakshmidu...7,889
23. larsberntrop6,999
24. KeremE6,850
25. chuckalici...5,543

1. sjef_bos...2,055,732
2. qwaletee1,669,865
3. SysExpert1,234,180
4. Hemantha...1,122,137
5. Bill-Hanson712,403
6. marilyng624,963
7. madhees...605,884
8. Bozzie4417,223
9. mbonaci387,667
10. p_partha352,219
11. brwwiggins295,862
12. Zvonko277,807
13. CRAK238,547
14. Arunkumar195,091
15. fgrushev...191,455
16. cezarF132,084
17. zvonko130,604
18. RanjeetRain111,054
19. olaraak108,291
20. jerrith107,809
21. HappyFun...102,184
22. mshogren94,313
23. ghassan9990,401
24. dragon-it80,007
25. scottrma68,271

Get values from view entries

Asked by shuboarder in Lotus Notes, Lotus Domino Email Server

Tags: Lotus Notes, lotusscript

About this solution