Database commands

The following is a list of the internal database commands of FootPrints, with short descriptions of their functions.  Each is discussed in more detail below, with syntax and examples.  

• mrABChange - Change the field of an Address Book Contact

• mrABList - List contacts in the Address Book based on search criteria

• mrABRegister - Create a single new contact

• mrABState - Change the state of a contact

• mrAppend - Append a new description to an Issue

• mrAssign - Assign users to an Issue

• mrAttach - Attach filenames to an Issue

• mrChange - Change the title, user field data, or most recent description data

• mrChangeTime - Change the time tracking date for an Issue

• mrDetails - View the details of an Issue

• mrEscalates - Escalate an Issue

• mrList,mrQuick,mrFast - List Issues based on search criteria

• mrNewPri - Change the priority of an Issue

• mrNewState - Change the status of an Issue/multiple Issues

• mrNewStates - Change the status of multiple Issues

• mrReference - Create a link between Issues

• mrRegister - Create a new Issue in the database

• mrShow - Show various fields for a given Issue

• mrTime - Read or write the time tracking data for an Issue

• mrUnassign - De-assign users from an Issue

• mrWriteHistory - Write the history for an Issue.

 Command Syntax

To execute these mr<name> commands in the /bin directory correctly, you must use the correct syntax, which depends on the system on which FootPrints resides.  The mr<name> command is now the first argument to one of the following, which must prefix those commands:

• Windows SQL/Access: perl\bin\perl mrFile.pl

• MySQL/Oracle/DB2/Postgres (Unix/Linux): mrFile.pl

Examples:

• Windows SQL/Access: c:\FootprintsServiceCore\bin\perl\bin\perl mrQuick.pl "mrSTATUS <> '_DELETED_'"

• MySQL/Oracle/DB2/Postgres (Unix/Linux): mrQuick.pl "mrSTATUS <> '_DELETED_'"