This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


Feb 12, 2016, 6:45 PM
21 Posts

Help with db.ftsearch with lotus script

  • Category: Application Development
  • Platform: Windows
  • Release: 9.0.1
  • Role: Developer
  • Tags:
  • Replies: 1

formatting my query for a full text returns:
​Notes error: Query is not understandable ([Body]"String1" AND "String2")

how can I properly format a query for FTSearch... the online help is useless in this scenario....

​dim searchText1 as string
​dim searchText2 as string
​dim condition as string   (for string return with a radio button... AND  OR )
​dim query as string
​dim test as string

searchText1 = uidoc.FieldGetText ("stringtextfield1")
​searchText2 = uidoc.FieldGetText ("stringtextfield2")
​condition = uidoc.FieldGetText("condition")

'searchtext1 returns "String1"
​'searchtext2 returns "String2"
​condition returns "AND" or a "OR" depending on RB choice.

test = |"| & searchText1 & |" | + condition + | "| & searchText2 & |"|
query = |[Body]| & test


Set searchCollection = searchDB.FTSearch ( b_query, 0 )  << error

I assume the query building problem is at "test =" , but I don't know. I've tried so many different way, I'm burnt.

Can anyone advise please?

 

Feb 12, 2016, 8:24 PM
1 Posts
You need an operator
([Body]"String1" AND "String2")

will not compile but

([Body] = "String1" AND [Body] = "String2")  

will.

and the operator CONTAINS is functionally equivalent.

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal