Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

searching a view with a web browser in an R5 database

Posted on 2000-04-25
5
Medium Priority
?
277 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 1600 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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…
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…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

604 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