FTSearch & Syntax
FTSearch & Syntax
(OP)
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
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
Talk To Other Members
RE: FTSearch & Syntax
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.