You are here: Chapter 8: Using Numara FootPrints > Searching and Reporting > Searching > Advanced Search Criteria

Advanced Search Criteria

The following options are available in the Advanced Search form, as well as the forms for Custom Reports, Time Tracking Reports, and Escalation and Business Rules (with minor differences):

Note

The names of many of the fields in FootPrints can be changed by the administrator (Title, Priority, Status, Description, etc.), as well as the name of the records (Issue).  Custom fields can also be created.  For clarity, this manual always refers to FootPrints records as “Issues,” and uses the default terms for the other field names.

  1. Issue Tab-General Information
  2. Title—Enter a word or phrase to for which to search. Boolean operators AND, OR, and NODATA are supported. Boolean Operators
  3. Description—If a word or phrase is entered (or multiple words using Boolean Operators), only Issues containing that word/phrase in the Description are returned.
  4. Keyword—If a word or phrase is entered, any Issues containing that word/phrase in any field are returned, including Title, Description, Workspace fields, and Address Book fields, as long as the full text search conforms to full text keyword search behavior.

Fields Included: The Keyword search queries theTitle field, Description field, Workspace (Issue), and Address Book fields.

Note on Permissions

Access to Issues is based on a user's Role.  Assignment options may be restricted based on your role. Please consult your FootPrints administrator for more information.

  1. Submitted by—If a user is selected, the search returns only Issues created by that user.
  2. Priority—Returns only Issues of the specified priority or priorities.  Highlight the priorities to be included; hold down the CTRL key to highlight multiple priorities.  To return all priorities, no priorities need to be selected (this has the same result as selecting all priorities).
  3. Status—Returns only Issues of the specified status(es).  By default, Open and any custom statuses are highlighted in the status dialog.  To select multiple statuses, hold down the CTRL key.  To return all statuses, no statuses need to be selected (this has the same result as selecting all statuses).
  4. Issue Tab-Issue Information—The fields in this section differ depending on the fields in the current Workspace.  Search on as many fields as desired. Search methods vary with the field data types:
    1. Character field—Displays a text box. Enter the word or phrase to search on (or multiple words using Boolean Operators).
    2. Number field—Displays a text box. Enter the number or part of a number for which to search.
    3. Drop-down and Multi-select field—Displays a multi-select dialog box. Highlight one or more values to search on.  To search for Issues that contain no data for the field, select No data.  If you do not want to restrict the search based on choices in a field, do not highlight any values.
    4. Date fields—Search on a date or date range. Date Field Search Options

    Note

    Date/time fields can only be searched by date, not time.

    1. Other field types—Email, URL, and FTP fields display a text box. Enter the word or phrase to search on (including partial addresses).
  5. Contact Tab—Search by users' contact information. The fields in this section differ depending on the fields in current Address Book.  Search methods are the same as those for Issue Information fields (see above).
  6. Advanced Criteria Tab
  7. Issue Types to Include—Specify whether Advanced Issue types, including Subtasks and Global Issues, are returned. Options include:
  8. All Issue Types—All Issue types are returned.
  9. Regular Issues—Regular (non-Global or Master/Subtask) Issues are returned.     
  10. Include Master IssuesMaster Issues that contain subtasks are returned.
  11. Include Subtasks—Subtasks of Master Issues are returned.            
  12. Include Global IssuesGlobal Issues are returned.
  13. Include GlobalLinks—All users' Issues linked to a Global Issue are returned.
  14. Group Master Issues with Subtasks/Global Issues with Global Links—Available for Reports only. These options override the sort order selected in the report.
  15. Date—If dates are specified, the search returns only Issues from the time period specified. Date Field Search Options

Note

It is important to understand the meaning of relative periods and aging in order to obtain accurate information, especially as the searching and reporting functions of FootPrints rely on the same types of criteria.  If a search is requested on Issues for "the previous three months," and the date is the 15th of May, then the period searched or reported on will be from February 15th through May 14th, inclusive.  That is, the report or search will exclude the current date and give the three month period prior to the current date.  This is to ensure that reports and searches yield consistent results.  If reports and searches included the current date, then the results might differ depending on the time of day at which the search or report was performed.

  1. Time—Specify the time in which the Issues were created or last edited based on the 24 hour clock. Available for Reports only.
  2. Age—Returns Issues created in the time specified.  Number of days and hours can be specified.  Modifiers are also provided, including “Greater Than”, “Less Than”, “Equal to”, “Greater than or Equal to”, “Less than or Equal to”, and “Not Equal to”.  As an example, to return Issues greater than 1 day old, choose “Greater than” and fill in “1” for “Days”.

Note

Age is always 24/7 and does not use the Workspace Work Calendar.

  1. Include Only x number of Issues found—Restrict the results to the first or last x number of Issues specified, for example, First 20 Issues. Available for Reports only.
  2. Include only Issue Numbers—Restricts the search to a defined range of Issue numbers.
  3. Advanced Date/Time Controls—The following "Pending Clock" options apply to the "Time to Close" and "Age" calculations (available for Reports only):
  4. Don't include time outside of the Workspace Work Calendar—If this is checked, the calculations do not include after-hours time based on the work calendar for the workspace. This option only affects output fields for reports such as Age of Issue. It does not apply to criteria on which FootPrints searches (even though it appears as an option in the criteria section of the page). What that means is, for example, if you set criteria for reports that have aged five days or more, when assembling the set of reports, FootPrints will not take this option into account and will use real time to determine whether the Issue is five days old or older. When the report is displayed, however, the Age of Issue will take the Workspace Work Schedule into account.
  5. Don't include time Issues spent in the following Statuses—Select one more statuses (Pending, Waiting for Customer, etc.) to exclude time spent for the "Time to Close" and "Age" calculations.

Note

These time calculations are always based on the time zone in which the server resides.

     

  1. And/Or—If “And” is chosen, Issues must match ALL criteria chosen above (this is the default).  If “Or” is chosen, only one criterion must be met.
  2. Save/Run Tab—Save the search criteria as a queue. Choose “Personal” to save search for yourself.  Choose “Shared/Internal” to share your search with other internal FootPrints users. “Shared/Public” is available for reports only to allow all users (including Customers) to access the report (the report will only contain data user is allowed to see).  Saved search queues appear in the Display Drop-down on the homepage.

For all text fields, regardless of section, entering just the % symbol finds all Issues with any data in that field.

When you are finished filling out the form, click GO to submit search. The Homepage is displayed with a list of matches.  If a name was entered for the search, it appears as a queue in the Display drop-down.