My searchFormula in lotusscript is not working

HCL Domino Domino Forum
1

Hi

I am trying to get my searchformula to work, but I am struggeling with { | and " symbols.

ProxyNameList and ProxyAxtion are fields on documents and unam is a variable in my script.

searchFormula$ = { Form = “AdminRequest” & (@Name([CN] ; ProxyNameList) = @Name([CN] ; unam )) & ProxyAction = “6” }

Can someone help me out?

Regards

2

Subject: My searchFormula in lotusscript is not working

searchFormula$ = { [Form] = “AdminRequest” AND [ProxyNameList] = @Name([CN] ; unam ) AND [ProxyAction] = “6” }

The comparison on the two names is a problem, because you can’t apply formatting to a field in the target documents as you search them.

You might be better off creating a view for this search based on the ProxyNameList as the first sorted column in the format you want to search on.

A good way to test these search formulas is to type them directly into the search bar of the database.

  • Matt
3

Subject: My searchFormula in lotusscript is not working

if unam is a LS variable, then it should be :

searchFormula$ = { Form = “AdminRequest” & (@Name([CN] ; ProxyNameList) = @Name([CN] ;} + unam + {)) & ProxyAction = “6” }

I presumed you’re talking about a selection formula. If you’re trying to use FT-searching, look at Matt’s response.