Staff

Start the search with a '#'.

Advanced searches contain a combination of field:value pairs.

The search will match the value against the contents of the field.

Fields are one of the following types:

1. Yes/No fields, like 'block', allow a few different entries to represent a Yes value: 'Yes', 'yes', 'Y', 'y' or a '1' all will search for Yes.
   Any other value for a Yes/No field means search for a No.

2. Words fields, like 'myschooldomain.com', consist of one or more words. Enter some of the letters, or all the letters, in a word to search for the word.

   To search using multiple words in the same field, surround the words with quotation marks.

ANY - With some fields, like estat, or noMail, it is hard to know exactly what to enter for the search. To find all leads with some kind of estat enter . That is 'ANY' (all capitals) for the value and the search will return all leads that have at least one character in the field.

NONE - To find all records without at least one character in a field then enter . That is 'NONE' (all capitals) for the value and the search will return all records that do not have at least one character in the field.

Date fields, like 'sent', have the year, month and day organized as YYYY-MM-DD.

'YYYY' is the four digit year, 'MM' is the two digit month and 'DD' is the two digit day of the month.

If the day is omitted then '01' is used. If the month is omitted then '01' is used.

Use a '~' to indicate a range of dates. '2014~' means on, or after, 2014. ''~2014' means 2014 or before.

To find records between two dates (like sent on, or after, May 1st, 2013 but before, or on, August 1st, 2014) put a '~' between the dates: .