Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 380
  • Last Modified:

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.
0
koray_uygun
Asked:
koray_uygun
1 Solution
 
koray_uygunAuthor Commented:
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
 
Sjef BosmanGroupware ConsultantCommented:
Your db is FullText-indexed?

If you only have to search one db, then use db.FTSearch. The string seems okay to me.
0
 
koray_uygunAuthor Commented:
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!

 
Sjef BosmanGroupware ConsultantCommented:
I used to create a simple Folder for this purpose, and PutInFolder on the whole NotesDocumentCollection. There must be a better way, though :|
0
 
Bozzie4Commented:
Change your formula to this:

|FIELD txtCONumber CONTAINS KULT-6A2LND|

That will definitely give you a result using db.ftsearch

cheers,

Tom
0
 
Sjef BosmanGroupware ConsultantCommented:
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
 
p_parthaCommented:
Tom
I don't think that will make any difference.. But koray_uygun you can try this:

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

Partha
0
 
koray_uygunAuthor Commented:
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
 
koray_uygunAuthor Commented:
Please close this question.
0
 
Sjef BosmanGroupware ConsultantCommented:
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
 
OzzModCommented:
Closed, 250 points refunded.
OzzMod
Community Support Moderator (Graveyard shift)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now