asked on

Lotus client custom search form

Hi,
I need to create a form with a Query field and a button that searches the db for the matching docs and displays it in a view (embedded view of the search form if possible) with relevance markers and all in Lotus client (not web). Can you give me the code for the button and the way the form has to be made please?
I have tried this code :

Set srdoc = db.ftdomainsearch("FIELD txtCONumber CONTAINS ""KULT-6A2LND""", 100)

but even if a doc that matches to this formula exists (proven with the built-in search of the views) it says it cannot find any matching doc.

Thanks in advance,
Koray.

koray_uygun

ASKER

For exemple, I have copied to my DB the search form and the result form of the catalog DB, it does not work neither, my DB is indexed, have I misconfigured something?

Sjef Bosman

Your db is FullText-indexed?

If you only have to search one db, then use db.FTSearch. The string seems okay to me.

koray_uygun

ASKER

Hi, yes, it is full text indexed. If I use ft search, how do I display the collection?

Sjef Bosman

I used to create a simple Folder for this purpose, and PutInFolder on the whole NotesDocumentCollection. There must be a better way, though :|

Bozzie4

Change your formula to this:

|FIELD txtCONumber CONTAINS KULT-6A2LND|

That will definitely give you a result using db.ftsearch

cheers,

Tom

Sjef Bosman

Hi Tom, what's the big difference? AFAIK quotes are permitted in a query, and sometimes even required.

Interesting that a field is called ...Number and contains text. What's in a name... :)

p_partha

Tom
I don't think that will make any difference.. But koray_uygun you can try this:

|FIELD txtCONumber CONTAINS "KULT-6A2LND*"|

Partha

koray_uygun

ASKER

Thank to you all but I have found a work around solution. As the users requested a search on 3 possible fields, I have created a from with 3 fields and an embedded view that displays single category in which the first column is categorized and displays an array formed by the sum of the 3 fields and displayed as separate entries...do you follow? That is not great in terms of maintenance (ie a new field...) but it is ok for now.

koray_uygun

ASKER

Please close this question.

Sjef Bosman

It's up to you to close this question, it's yours :)

Place a new question in Community Support that you want this question closed, and how. Wheels will get in motion then.

ASKER CERTIFIED SOLUTION

OzzMod

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial