GoldMine Filters have a 255 Character Limit

There is a limit of 255 characters for a filter expression in GoldMine. When doing a large OR comparison the 255 character limit can be reached quite easily. For example, you may want to filter based on a group of contact records whos state is CA, MA, NY, KY, OH, and so on. A better way to do this would be to use a  shorter dbase expression using the  $ (the “contains” operator). For example, use the following: contact1->state $ “CA MA NY KY OH”

NOTE:  Be sure to check the “dBase Exp”  check box and then type contact1->state $ “CA MA NY KY OH” into the dbase expression window. If you need help with more complex filters/dbase expressions please contact First Direct Corp. directly.