FTSearch & Syntax

[mutancik]

Hello!

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

Firma$=profile.RP_Firma(0)
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 ....

Joanna

 

[Giaggio]

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.