Filter Ticket

Parent Previous Next


The Ticket Lookup Filter is accessed via the top tab on the SMSTurbo Ticket Lookup screen.  Use the filter tab's data grid to add extra filter rules to the data currently in the Lookup Browser.  The Data Column is the SMSTurbo ticket field that will be filtered against. The Operator column is the type of filter to apply against the ticket value. The Search Value is the text for field value that you want to search or filter against.

Setting the Operator column to anything other than NO FILTER means that column will be included in the filter. Once you choose a row in the Data column, select an Operator and enter a value into that row's Search Value column.

A simple example would be:

NOTE : The filter only filters data using the From and To Dates set in the Lookup screen.

Using the LIKE operator:

When using the like operator you can find partial results.  For example, if you wanted to see all tickets for customers who's ID begins with CUS

The percent sign (%) can be used in front of or at the end of any Search Value text to act as a wild card and will return any results that are LIKE the text inside the % field.