Actions  

Here is a list of Action names, and what sorts of things happen when each action is performed:

  • AddAttachments - Attaches files to a particular task. Uploads one or more files to the server and inserts rows into the attachment table.
  • AddCat - Creates a category for categorizing tasks and faqs. Inserts a row into the cat table.
  • AddCustomField - Creates a custom field and its possible values. Inserts a row into the customfield table, and inserts rows in customfieldvalue for each possible value.
  • AddDepartment - Creates a new department by inserting a row into the department table.
  • AddFaq - Creates a new faq. Inserts a row into the faq table, and possibly also into the followup and followupdetail tables (if there are any followups).
  • AddFilter - Creates a new filter for controlling what is displayed in the Browse Tasks listing. Generates sql where and order by clauses and inserts them into the filter table.
  • AddHomePageItem - Adds a paragraph to the homepage. Inserts a row into homepageitem.
  • AddProduct - Creates a new product. Inserts a row into the product table.
  • AddSection - Creates a new user section for controlling access rights. Inserts a row into the section table, as well as rows into the sectiondisplay and sectionaction tables.
  • AddTask - Creates a new task. Inserts a row into the task table, and possibly also into the followup and followupdetail tables (if there are any followups).
  • AddUser - Creates a new Willow user. Inserts a row into the person table.
  • AddVersion - Creates a new version for a particular product. Inserts a row into the version table.
  • ChangePassword - Changes the user's password in the person table. (This logs them out.)
  • DeleteAttachment - Deletes a row from the attachment table, thereby disassociating a task from its attachments. The actual attachment file is left on the server.
  • DeleteCat - Removes a category from the system. All columns referencing that category will be set to SQL NULL. Deletes rows from cat, and updates rows in task and faq.
  • DeleteCsv - When the report link is clicked, a CSV file is created on the server. This action deletes that CSV file from the server. Automatically performed when the "Get CSV" popup is closed.
  • DeleteCustomField - Removes a custom field from the system. Deletes the custom field from customfield, deletes the custom field values from customfieldvalue, and removes all task associations from taskcustomfield. The table customfieldsettings is regenerated minus the column names corresponding to the possible values of this custom field.
  • DeleteDepartment - Removes a department from the system. Deletes a row from the department table. Use with caution.
  • DeleteFaq - Removes a faq, all of its followups, and all of its attachments from the system. Deletes rows from faq, followup, followupdetails, and attachment.
  • DeleteFilter - Removes a task filter from the system. Deletes a row from the filter table.
  • DeleteHomePageItem - Removes a paragraph from the homepage. Deletes a row from the homepageitem table.
  • DeleteProduct - Removes a product from the system. All columns referencing the product will be set to SQL NULL. Deletes rows from product, and updates rows in task, faq, and version.
  • DeleteSection - Removes a user section from the system. Deletes a row from the section table, and possibly rows from the personsection, sectiondisplay, and sectionaction tables.
  • DeleteTask - Removes a task, all of its followups, and all of its attachments from the system. Deletes rows from task, followup, followupdetails, and attachment.
  • EditCat - Modifies a category. Updates a row into the cat table.
  • EditCustomField - Modifies a custom field. The name of the field may be modified, and values may be added or removed. Updates a row in the customfield table, as well as multiple rows in customfieldvalue and taskcustomfield. The table customfieldsettings is regenerated.
  • EditDepartment - Modifies a department. Updates a row in department.
  • EditFaq - Apply changes to a faq. Updates a row in the faq table. Inserts rows into the followup and followupdetail table.
  • EditFilter - Modify a task filter. Updates a row in the filter table.
  • EditHomePageItem - Change text on the homepage. Updates a row in the homepageitem table.
  • EditIniConfig - Edit the willow.ini file. USE EXTREME CAUTION! The original file is backed up before any changes are applied. Also inserts a row in the settings table to track who made the change.
  • EditProduct - Modifies a product. Updates a row into the product table.
  • EditSection - Apply changes to a user section. Updates a row in the section table. Deletes and reinserts rows in the sectiondisplay and sectionaction table.
  • EditTask - Apply changes to a task. Updates a row in the task table. Inserts rows into the followup and followupdetail table. If custom fields are enabled, inserts or deletes rows in taskcustomfield and regenerates customfieldsettings.
  • EditUser - Apply changes to a Willow user. Updates a row in the person table. Deletes and reinserts rows in the personsection table.
  • EditVersion - Modifies a version. Updates a row into the version table.
  • ForwardFaq - Forward a text copy of a faq to an arbitrary email address. Recorded in the faq followups, meaning a row is inserted in followup and in followupdetail.
  • ForwardTask - Forward a text copy of a task to an arbitrary email address. Recorded in the task followups, meaning a row is inserted in followup and in followupdetail.
  • GetAttachment - Download an attachment. Sets the Content-Type, Content-Length, and Content-Disposition headers and then sends the attachment file as a stream of bytes to the user's browser.
  • HomePageAlert - Toggles homepage alerts on and off. The effect is to cause the "home" icon to flash, indicating to the user that they should check the homepage for important information.
  • Login - Logs in a user. You should allow this for everyone.
  • Logout - Logs out a user. You should allow this for everyone.
  • MoveHomePageItem - Moves a paragraph on the homepage up or down. Updates a row in homepageitem.
  • ObsoleteVersion - Marks a product version as being obsolete. Updates a row in version.
  • SelectAdminContact - Allows you to specify the point of contact between ordinary users and Willow administrators. The effect is to cause a mailto: link to appear in the sidebar. Deletes and re-inserts a row in the settings table.
  • SelectFilter - Choose a filter to control what is displayed in the task listing. Modifies a row in the ustate table.
  • SubmitBugReport - Send a bug report or enhancement request to the Willow maintainers.
  • TurnOffFiltering - Turns off filtering, so that all tasks in the system are displayed. Deletes a row from the ustate table.
  • UnobsoleteVersion - Marks a product version as being no longer obsolete. Updates a row in version.
  • UstateCleanup - Removes rows from ustate that are older that a specified date. Used infrequently.