Solved

searching a view with a web browser in an R5 database

Posted on 2000-04-25
5
273 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

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!

Question has a verified solution.

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

For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

717 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