Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

FTSearch & Syntax

FTSearch & Syntax

FTSearch & Syntax


I have a question ... about FTSearch. i try to find sh on this form but solutions which I found doesn't work ...

I have agent which should find some docs, which are filtered by "Profile document"

Everything work great beside my search formula :-)

when i set:

searchFormula$ = {Form = "ala"} then it finds all docs, and it is good but when i try to use profile document then I have errors or don't find any documents

I tried:

searchFormula$ = {FIELD FIRMA_1 CONTAINS } + {"} & Firma$ & {"}
searchFormula$ = {FIELD FIRMA_1 CONTAINS }+Firma$
searchFormula$ = " [FIRMA_1] = "+Firma$+" "
searchFormula$ = " [FIRMA_1] =Firma$ "

these don't work....

If you know any solution, I will appreciate ....


RE: FTSearch & Syntax

Your first searchFormula works fine in a test of mine!
I will test the others tomorrow but its not seems correct.
Ask yourself some question:
- Is my db correctly indexed ?
- Firma$ contains a rigth value for the search or contains some wrong char (i.e. some spaces)? (use the debugger to verify it)
- In the FT index of the db there is difference from upper and lower case ? If so, Firma$ is right capitalized?
And, finally, the last important question I ask to you:
You're using FTSearch from Notesdatabase, Notesview, Notesdocumentcollection or NotesViewEntryCollection class?
Let me know and we'll find a solution.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close