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 “_%”


Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!