LookupPreFilter Operators in the Infor CRM web client

A long time ago I wrote about how to add a pre condition to a lookup control in the Infor CRM web client. I realized that I had not really specified the options when creating a new LookupPreFilter, specifically what options you have in the OperatorCode. When you add a lookup pre-condition at design time you get to specify the operator using logical descriptions like Equals, Greater Than, Contains, etc. However when adding a Lookup pre-condition at runtime you have to pass in different values. Let’s take a look at the acceptable options:

• “%xx” Starts With
• “x%x” Contains
• “=” Equal To
• “!=” Not Equal To
• “gt” Greater Than
• “ge” Greater Than or Equal To
• “lt” Less Than,
• “le” Less Than or Equal To

There is no option for contains data but you can use the operator of “x%x” With a FilterValue specified of “_%”