Solved

searching a view with a web browser in an R5 database

Posted on 2000-04-25
5
268 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
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.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

910 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now