Solved

searching a view with a web browser in an R5 database

Posted on 2000-04-25
5
269 Views
Last Modified: 2013-12-18
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
0
Comment
Question by:DevonCLS
5 Comments
 
LVL 1

Expert Comment

by:cfmrulez
ID: 2749014
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
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 2749151
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
 
LVL 3

Accepted Solution

by:
Simon_Hendry earned 400 total points
ID: 2749467
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
 

Author Comment

by:DevonCLS
ID: 2752842
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
 
LVL 1

Expert Comment

by:jz6pwc
ID: 2761400
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

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

785 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