Query not understandable FTsearch for multiple value

HCL Domino Domino Forum
1

I has the following code to perform Ftsearch on multiple field with multiple values

Set curdb = session.CurrentDatabase		

Set uidoc = ws.CurrentDocument

Set curdoc = uidoc.Document



searchsubstring1 = ""

For i=0 To Ubound(curdoc.PDPolicyNumberAll)

	If i=0 Then

		searchsubstring1 =	 curdoc.PDPolicyNumberAll(i)		

	Else	

		searchsubstring1 =	searchsubstring1	& {":"}& curdoc.PDPolicyNumberAll(0)

	End If		

Next



searchsubstring2 = ""	

For i=0 To Ubound(curdoc.PDHKIDPassportAll)

	If i=0 Then

		searchsubstring2 =	 curdoc.PDHKIDPassportAll(i)		

	Else	

		searchsubstring2 =	searchsubstring2	& {":"}& curdoc.PDHKIDPassportAll(0)

	End If				

Next



casetype =  curdoc.CaseType(0)

If searchsubstring1 <> "" And searchsubstring2 <> "" Then

	If searchsubstring1 = "" Then

		searchFormula = {Form = "Customer Feedback" & (CaseType="} & CaseType & {") & _

		(PDHKIDPassportAll*="} & searchsubstring2 & {")} 						

	Elseif searchsubstring2 = "" Then

		searchFormula = {Form = "Customer Feedback" & (CaseType="} & CaseType & {") & (PDPolicyNumberAll*="} & _

		searchsubstring1 & {")}

	Else	

		searchFormula = {Form = "Customer Feedback" & (CaseType="} & CaseType & {") & ((PDPolicyNumberAll*="} & _

		searchsubstring1 & {") or (PDHKIDPassportAll*="} & searchsubstring2 & {"))} 			

	End If

	Set dc = curdb.FTSearch(searchFormula,0)

Else	

	Print "Search Not found"		

End If

where PDPolicyNumberAll and PDHKIDPassportAll are mutliple values field, what is the problem with my code?

The searchFormula is equal to

“Form = “Customer Feedback” & (CaseType=“Complaint”) & ((PDPolicyNumberAll*=“000009558000”:“000009558000”) or (PDHKIDPassportAll*=“K0977403”:“K0977403”:“K0977403”))”

2

Subject: Query not understandable FTsearch for multiple value

Looks like you’re confusing ViewSelection with FTsearchQuery

Your final query should look like:

[Form]=“Customer Feedback” & [CaseType]=“Complaint” & ((([PDPolicyNumberAll]=“000009558000”)|([PDPolicyNumberAll]=“000009558000”)) | (([PDHKIDPassportAll]=“K0977403”)|([PDHKIDPassportAll]=“K0977403”)|([PDHKIDPassportAll]=“K0977403”)))