?
Solved

refresh a view after ftsearch via lotusscript

Posted on 2006-06-06
13
Medium Priority
?
3,393 Views
Last Modified: 2013-12-18
I want to develop a Serchform where i can search within a view.

I've done so far a Form with the Fields for searching the view.
Than i embedded the view what should be searched and added an Action to acces the fields in the uidocument for the ftsearch-query. i am able to search the view, but i want to just show the documents corresponding to result of the ftsearch. i tried it with workspace.viewrefresh but it doesn't work.

does anybody have any suggestions.
0
Comment
Question by:ragerino
  • 8
  • 5
13 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16840903
Notes or Web?
0
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 750 total points
ID: 16840909
Stupid question, sorry... :-$    Notes of course.

The result of an FTSearch is a collection of documents. You can put that collection in a folder and display the folder. I'll try to find a similar solution for you...
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16840912
Here is one:
    http:Q_21829701.html "Developing a form for searching a database"
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 3

Author Comment

by:ragerino
ID: 16840939
First, thanks for your fast answer.

My Boss is telling me that the performance of Folders is very bad. So is there an other way to only display the documents from the ftsearch in the embedded view (some kind of hidden fulltextsearchfield containing the searchstring [searchfield]="*searchvalue*").
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16840971
AFAIK... no, there isn't :(

You could use a form to display the info in a text field, but it wouldn't be the same as a view.

You could also try to prove your boss wrong...
0
 
LVL 3

Author Comment

by:ragerino
ID: 16841025
what about something like this:
http://www-10.lotus.com/ldd/nd6forum.nsf/55c38d716d632d9b8525689b005ba1c0/3aa0f80dd14bdfea85256f2500656d04?OpenDocument

i thought executing a macro what marks the documents i need as selected and then execute "View/Show/Selected Only" from the menu ???

Do you think this might work ???
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16841692
Marking documents selected in a view? AFAIK no such method or function available...

A much neater implementation to simulate keyboard input is this script library of a PushKeys function:
    http://www.benpoole.com/80256B44004A7C14/0/E67941803F1BC0C980256C1B0072EB20!OpenDocument
0
 
LVL 3

Author Comment

by:ragerino
ID: 16842293
O.K. i told him that the folder would be the easiest solution.

so i need for every user a own folder???

how do i create a folder and how do i put the documents in it.
because this database is used by about 200 people.

and whenever someone enters a searchstring i have to add the dc from ftsearch to the folder.

how do i do this???
0
 
LVL 3

Author Comment

by:ragerino
ID: 16842313
what is the select criteria for the folder(view) i create with:
db.createview("MyFolder" & username)
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16842530
The link I gave above (http:Q_21829701.html "Developing a form for searching a database") explains it all, the page even contains the necessary source code to populate the folder. Don't create the folder through code. Instead, it should be created in the database template, as shared, private on first use. Bear in mind that you will have to make special provisions when you need to change the folder in the future, as updating a private folder is impossible.

Adding the collection to the folder is just
    Call collectio.PutAllnFolder("foldername")

But that's also in the page above.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16847626
> Marking documents selected in a view? AFAIK no such method or function available...
This can be done using the NotesUIView.SelectDocument method. Whether it will work for multiple documents I never tested. You'd need a loop to walk through all documents in the collection.

Sorry, just re-discovered this method... :-$
0
 
LVL 3

Author Comment

by:ragerino
ID: 16850519
gave you only a "good answer" because filling up folders in notesclient and displaying them is not as easy because sometimes the previous result is displayed and the user has to hit f9 in the folder to see the actual result.

hope this is o.k. for you.
thanx for your help
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16851227
Hitting F9 can be cured using a ws.ViewRefresh.

I hope we'll meet again (and then I'll remember...)

Sjef ;-)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Loops Section Overview
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question