Email Queries

To receive information from FootPrints via email, several email queries are available.  To query FootPrints via email, send an email to the incoming email account for the Project in question using one of the queries described below in the subject line.

General Queries

• FPHelp—Returns this section of the help documentation (i.e., the section you are currently viewing).
• listprojects—Returns a list of Project names and corresponding Project numbers of all the Projects to which you belong.

Queries to the Database

The following queries return data for the default Project for incoming email as defined by the System Administrator.  If different email accounts are defined for each Project, a query sent to a particular Project’s email account returns information based from that Project.

To return data for a different Project to which you are assigned where that Project does not have its own email account, the line Project=ncan be placed in the body of the email, where n is the Project number.  It can alternatively be included in the subject line of the email in the form Proj=n.  The Project number can be retrieved with the listprojects query.  All searches are case-insensitive.

The following queries can be performed by placing the query in the subject of an email that is sent to the FootPrints incoming email account:

• getMine—Returns a list of your assignments.
• Getschema—Returns the Project field schema of a Project.  This describes the Project fields specific to the Project. 
• SearchFAQ “keyword”—Returns solutions based on a keyword found in the Title or Description, e.g., SearchFAQ printer.
• getTicket “number”—Displays the details of an existing Issue based on the Issue number (you must be assigned to the Issue), e.g., getTicket  235.
• getData “keyword”—Returns database Issues based on a keyword found in the Title or Description, e.g., getData Exchange.  This is for internal users only.  External users receive Solutions based on the keyword.
• HTML form—Returns an HTML form with all fields for Issue submission for a Project, e.g., HTML form or HTML form PROJ=5.