Schedules

<table>
<tbody><tr class="search_advanced_help_tr"><td class="vtop aleft" colspan="100">
<div class="showing_advanced_help search_is_empty">
<div class="header">
Advanced Search
</div>

<p>

Start the search with a '#'.

</p>

<p>

Advanced searches contain a combination of field:value pairs.

</p>

<p>

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

</p>

<p>

Fields are one of the following types:

</p>

    <ol style="margin: 0px 0px 10px 20px;">
  • <li>
    • 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.
  • </li>
  • <li>

    • <p>

    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.

    </p>

    <p>

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

    </p>

  • </li>
      • </ol>

    <p>

    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.

    </p>

    <p>

    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.

    </p>

    <p>

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

    </p>

    <p>

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

    </p>

    <p>

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

    </p>

    <p>

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

    </p>

    <p>

    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: .

    </p>

    </div>

    To search on a specific course, type in #coursestatecode: (include the course code after the colon):