searching a view with a web browser in an R5 database

We would like to setup the ability for users to search a view using a web browser in an R5 database.  Could someone please help and walk us through how to go about doing this?

Regards,
DevonCLS
DevonCLSAsked:
Who is Participating?
 
Simon_HendryConnect With a Mentor Commented:
Here is a step by step example of how to setup a nice customized view search in R5.

What you need to do is create two forms , one will be the form that people use for  entering their search parameters and the other will be a template for the screen that is returned to the user , you will also need to FULL TEXT INDEX the database and depending on whether you want people to have to authenticate or not change the ACL as required.

To create the form that people submit do the following..

Create a form called "SearchForm", place all of the graphics, pass thru html etc that you want on the form and also create a field on the form called "QueryString" and a button ( or Action Hotspot) with the Formula

DBURL:=@URLEncode("Domino";@SubSet(@DBName;-1));
QuotedQuery:=@URLEncode("Domino";QueryString);
@URLOpen("/" + DBURL + "/<ViewName>?SearchView&Query=" + QuotedQuery);

Replace <ViewName> with the name of the view you want to search

The @URLEncode function will handle all of the translation required for converting text to URL safe text.... Now save this form..

Now create a form called "$$SearchTemplateDefault" This will be the form used to display the results of the search...

On this form again place all the graphics and passthru html that you want and also create a computed rich text field called "$$ViewBody" ... The Domino server will render the results of the search in place of this field...

Now save the form...

Now replace any links n your database to "Search" with the formula
 
DBURL:=@URLEncode("Domino";@SubSet(@DBName;-1));
@URLOpen("/" + DBURL +"/SearchForm?OpenForm");

This will mean that the user will be taken to your search form to perform searches...

Once you have done this your database will now have the functionality to search a view with nicely custom made search forms !!
0
 
cfmrulezCommented:
First of all you must put that database as a public database in your root in order to let Domino serve them.

You can access them like this:
http:\\www.server.com\test\bd.nsf

This way you will have the nsf public on the Internet. You must play with the ACL to perfile the users that can access that database.

To make a search engine, create a form with and action button than performs this command:

@Do(@URLOpen("http://www.server.net/test/bd.nsf/view?SearchView&query="+SearchString);

Where SearchString is the one you want.
Ej. Lotus%20AND%20Notes.

Is easy to make a form with an action button that perfoms this search generating de search string dinamically.

Hope this helps,
cfmrulez!
0
 
HemanthaKumarCommented:
Hi

You can use "$$ViewTemplate for <view name>" form and customize the appearance. In that form use an hotspot "Search" with command -@Command([ViewShowSearchBar])-

This would bring up the default search form used by Domino.

Good Luck
~Hemanth
0
 
DevonCLSAuthor Commented:
This was the answer that most helped me.
The key was to full text index the database.  Thanks to all that responded.

Thanks Simon for that step by step walk-through.

Best Regards,
Devon
0
 
jz6pwcCommented:
How would you modify this approach if you were using a form with an embeded view and you wanted the search results returned to the embeded view?
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.