As I promised last time (though it’s been so long, everybody probably forgot), I took Mark’s clever hack and turned it into a function that anybody can use in a business rule. For example, let’s say you want to filter out any items that have certain words in their titles; namely, the words:

  • great
  • big
  • large

How do we write a rule that will filter out items with any of those words in their titles? Simple; just create a lookup list with those words in the “name” column (the “value” column is completely irrelevant in this case). Let’s say you named the list “special words.” Then you just write the following rule (assuming your title field is called offername; if not substitute the proper field name):

CONTAINSWORDLIST("special words",$offername)=TRUE

That’s it! Now if you apply that rule as a filter in your template, any items with the words “great,” “big,” or “large” will be removed from your outgoing feed. One thing to remember: it is NOT case sensitive. Here are some examples:

Title Is It Filtered?
Great Big Widget Yes
Large Bag Of Stuff Yes
Small Piece of Fluff No

Enjoy!

Share This