?
Solved

Lotus client custom search form

Posted on 2005-03-01
12
Medium Priority
?
379 Views
Last Modified: 2013-12-18
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.
0
Comment
Question by:koray_uygun
[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
12 Comments
 

Author Comment

by:koray_uygun
ID: 13428223
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?
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 13428528
Your db is FullText-indexed?

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

Author Comment

by:koray_uygun
ID: 13429376
Hi, yes, it is full text indexed. If I use ft search, how do I display the collection?
0
Industry Leaders: 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!

 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 13429487
I used to create a simple Folder for this purpose, and PutInFolder on the whole NotesDocumentCollection. There must be a better way, though :|
0
 
LVL 15

Expert Comment

by:Bozzie4
ID: 13430611
Change your formula to this:

|FIELD txtCONumber CONTAINS KULT-6A2LND|

That will definitely give you a result using db.ftsearch

cheers,

Tom
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 13430742
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... :)
0
 
LVL 14

Expert Comment

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

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

Partha
0
 

Author Comment

by:koray_uygun
ID: 13448480
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.
0
 

Author Comment

by:koray_uygun
ID: 13448482
Please close this question.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 13449600
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.
0
 

Accepted Solution

by:
OzzMod earned 0 total points
ID: 13746237
Closed, 250 points refunded.
OzzMod
Community Support Moderator (Graveyard shift)
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
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…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month12 days, 17 hours left to enroll

777 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