Filter Records Using An 'OR' Operator

Insycle defaults to the 'AND' operator, like missing 'First Name' AND 'Last Name.'

But filtering data using multiple fields and using the 'OR' operator (such as Missing 'First Name' OR 'Last Name') is easy.

First, you set up your Insycle template using the fields that you would like. Then you click the "Advanced" tab, remove the "+" from the syntax. Then you can filter using multiple fields using the 'OR' operator.

Add the fields that you would like to filter by using the 'OR' operator.

In our example, we will use the Bulk Operations module. We will set our filter up to filter for records with missing first names and last names.

 

Now, as is, this is looking for "Missing first name AND Missing last name." Insycle does this by default.

But we want to search for "Missing first name OR missing last name."

With your filter set up, click the "Search" button. This generates the advanced syntax for the search.

In the Record Viewer at the bottom of the page, you'll see that the only contacts are those that are missing both the 'First Name' field and 'Last Name' field.

 

Now click the "Advanced" tab in Step 1. You'll see the advanced search syntax for this filter has been generated.

 

In the advanced search syntax, before the syntax for each field, you'll see two "+" signs. These "+" sings are what signals to Insycle that the filter will use 'AND.' If you remove these, Insycle will search for both fields using 'OR.'

 

Remove the "+" signs from your advanced search syntax.

 

Now, if we click the Search button, Insycle will search for records that are missing first name OR last name.