Using Advanced Search

Every list has has a search bar offering two options: a basic search (e.g. for a keyword) and an advanced search that allows more complicated filtering.

Any searches you do only affect this Method session. If you refresh your browser or sign out and sign back into Method, your search will be lost and you will need to search again.

Finding advanced search

By selecting the Advanced link within the search bar, you will open up another window to allow for more advanced filtering: 

Depending on which app you're using, the advanced search offers options to filter based on the fields in the app's base table

For example, here's what the advanced search looks like on the Contacts List:

The advanced search GUI

  1. This line shows how many filters are currently in effect.
  2. This X will close the advanced search dialog box, but will not remove the filters.
  3. These are selectable fields to add search conditions.
  4. The Clear button will clear out all filters in advanced search
  5. The blue Search button will filter the grid using the search conditions you set.

What advanced search searches

The Advanced search allows you to search through fields available on the grid, and fields not available on the grid.

For example, in the below contacts grid, the billing address for the city is not shown in the grid. However, you can still search through your contacts based on the city using the Advanced search:

However, not all fields of a table are included by default in the advanced search. Through customization, you can choose to add more fields to the advanced search in case the fields do not show. 

Adding a search term to advanced search

When you select a field within the advanced search box, it will expand to show an ⊕ Add button.

By selecting the ⊕ Add button adds a new condition:

This condition has two boxes, a comparison and a value. By defining a condition, you can have the grid only display records which match that condition.

For example, let's create the following condition:

In the above, the comparison is set to "Greater Than", and the value is set to zero. Note the number in brackets beside Balance? That indicates how many search conditions have been added to this field. Currently, we only have one.

If you were to hit the blue search button, this would filter the contacts grid so that only contacts with a balance greater than $0 will be shown.

For more information on other search comparison options, see below.

Adding multiple search terms to advanced search

By adding a search conditions to multiple fields, you can filter the grid so that it will only find records which match ALL of the conditions.

In the below example, I have added a search condition to the Balance field ("greater than zero" which is not pictured), and I have added a search condition to the Billing Address City field ("equals Chicago"). 

When the grid is search, only the records where both these conditions are true will be shown. So a contact must have a balance greater than zero, and their billing address must be set to "Chicago".

Note you can also have multiple conditions within the same field. There is a difference here, though. Records will be shown if any one of the conditions within that field is true.

In the below example, we have set up two search conditions within the same field. We are searching to see if the contact's city is either "Chicago" or "New York".

So in the above example, only contacts who having their billing address set to either "Chicago" or "New York" will show. 

And what happens when we start combining these together? Let's take a look at the below example (Balance is set again to be greater than zero). There are now three search terms:

In order for a contact to show up in the grid, the contact must have a balance greater than zero, and they must be in either "Chicago" or "New York" for their billing address.

Advanced search comparison options

There are a number of other comparison options you can choose from:

  • Equals
  • Not Equals
  • Less Than
  • Less or Equal
  • Greater Than
  • Greater or Equal
  • Is Empty
  • Is Not Empty

Depending on the field type, however, there will be other options.

  • Yes/No fields will only have two selectable values to filter on, yes or no
  • Tags field allow you to select tags to include and exclude
  • Date & Time fields changes things up a bit:
    • Compare As:
      • Date & Time
      • Date
      • Date of Month
      • Month
      • Year
      • Day of Week
    • Comparison:
      • Equals
      • Not Equals
      • Before
      • After
      • On or before
      • On or after
      • Empty
      • Not Empty
    • Value: the date to compare to


Was this article helpful?

Can’t find what you’re looking for?

Contact Us