O R G A N I C / F E R T I L I Z E R: opalis: pattern matching with the remedy integration pack

Sep 7, 2010

opalis: pattern matching with the remedy integration pack

in my testing with the remedy integration pack, I found that the filtering behavior did not work as expected.  to be very clear on that, I wasn't sure what to expect since the documentation provides no detail on the acceptable wildcards for pattern matching. 

what am I talking about?  let's examine the "get request" help.  under the filters section, it notes the following:

Configure the criteria for requests that you want the Get Request object to retrieve. See below for instructions on configuring the filter criteria. You must use at least one filter.

Note: Opalis Software, Inc. recommends that you use restrictive filter conditions to avoid retrieving large amounts of data.

yeah, not entirely useful.  probably just a documentation omission -- albeit a critical piece of information.


this is a screenshot of a typical filter:



in this screenshot, I'm attemping to search for all records that match on a short description that begins with OIS.  now, speaking in generalities, the acceptable wildcards are usually "*" or "?".  I assure you, I've tried them both to no avail.  the magic wildcard that works with the remedy integration pack is the "%" value.  this is typically what you use in sql queries.

here's the forum topic where we discussed this behavior: http://social.technet.microsoft.com/Forums/en-US/opalisint/thread/9e98e9b4-0980-499d-94e2-856b58d25ef0