view.FTSearch

HCL Domino Domino Forum
1

Hi All,

I have created a form with several fields which takes input from user and search the document from a view. This is web based application. The fields are

Designation - Text

Location - Dialog list

Qualification-Dialog list

Work Exp From - Number

Work Exp From - number

Salary-Number

Now I want to make a ftsearch using this parmaters

Like

I need those document which has

Location = “Delhi”,“Mumbai”

Qualification=“MBA”,“B.Tec”,“MCA”

Designaion=“Seinor Engineer”

Work Exp From = 5 '(yr)

Work Exp To = 10 '(yr)

salary between 6 to 10 (lakhs)

As what we did in Microsoft Application and fetching data from SQL or Oracle

Is it possible in Lotus notes using view.FTSearch. If yes please help me how do i create Query and where result will display.

I go through the multiple forum which is posted here where user want to search the document from the view.

I have a view named “vUregisterUser” which contains the document from which I want to filter.

I will be very thank ful to you for your kind response.

With Regards,

Vikas K Sinha

2

Subject: view.FTSearch

Why do you need to use LotusScript for this? Can your users not just use the native Search functionality? You may want to use Search by Form (see Domino Designer Help page “Customizing search forms”, for example.

Cheers,

Adrian

3

Subject: RE: view.FTSearch

First of all I would like to say thanks for all.

I have created a SearchTemplate and also created from which contains all the fields what I wrote earlier. The problem is how could i create a query. I mean to say syntex of the query.

What I created:

http://ServerName/DatabaseName/viewName?SearchView&Query=(FIELD presentcompany=Group OR Field loginid=sharma) AND field id=@yahoo.com

This is working fine. But I need to explore it. Let say if i want to make a search in which

presentCompany=Minda Group or RSA or TCS or HCL

and id=@yahoo.com or @rediffmail.com

Actually I need syntex for query conjuction with multiple fields with AND,OR & NOT.

Could you build a query for me using my first posted data just for an example. Actually I have more than 25 fields from which i have filter data.

I will be very thankful to all of you.

Thanks Andre Guirard…(Need more help)

Thanks With Regards,

Vikas K Sinha

4

Subject: RE: view.FTSearch

You can do as Adrian suggests and create a search form. Read about $$SearchTemplate in the Designer help, and the query syntax is fully described in the user help files. Basically, you can have a form constructs a URL in the $$Return field which includes your query, and this will display in the browser using a page you specify to control the formatting.