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.

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!