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.
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 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.
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.
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.
There are a number of other comparison options you can choose from:
Depending on the field type, however, there will be other options.