Issue Tracking Sample Application

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

The Issue Tracking sample application takes advantage of the core features of the Workflow Designer for SQL Server, which is a part of Microsoft® Office XP Developer. The application makes it possible for you to track an issue through a series of states or steps in a business process.

The Issue Tracking sample is included as a template when you install Workflow Services for SQL Server from the Office XP Developer CD. You can use the Workflow Manager for SQL Server to create an instance of the Issue Tracking sample application on your server, and it is ready to use. You can customize the application to your specific requirements or use it to learn how to create a new workflow application.

To use the Issue Tracking sample application, you first must create an instance of the application from the template. For details, see Creating Workflow Applications Based on Templates. Then, you can open the application in the Workflow Designer to see how it works.

In This Section

• The Web Pages in the Issue Tracking Sample Application
  The Issue Tracking sample application is built around a series of data access pages. Workflow functionality is implemented using the Microsoft® Visual Basic® Scripting Edition (VBScript) within the data access pages and by including Web pages created using Microsoft® JScript®. All of these files work together to complete the application.
• The Structure of the Issue Tracking Sample Application
  The Issue Tracking sample application consists of a Web-based user interface and a Microsoft® SQL Server™ database. The primary pages used in the Issue Tracking application were created using Microsoft® Access data access pages.
• Workflow Functionality in the Issue Tracking Sample Application
  The main interface to the workflow functionality in the Issue Tracking sample application is the workflow control bar that is displayed on the Grid View and Detail Form pages.
• Row-level Security in the Issue Tracking Sample Application
  The Issue Tracking sample application makes it possible for users to specify row-level security settings for each issue defined in the database.

Related Sections

• Developing Workflow Applications for SQL Server
  Simplify the task of creating typical workflow applications, such as forms routing/approval, document review/publishing, and issue tracking, by using the workflow engine and specialized workflow modeling tools of the Workflow Designer for SQL Server.
• Workflow Applications Architecture for SQL Server
  Understand how the Workflow Designer for SQL Server and Workflow Services for SQL Server help you build, modify, and add script to workflow applications on a database.
• Planning Workflow Applications for SQL Server
  Plan your application before starting. Numerous considerations make application development much easier if they are addressed from the start - for example, security and schema.
• Building Workflow Applications for SQL Server
  Set up a table hierarchy, and build a workflow process for your workflow application.
• Developing the User Interface for SQL Server
  Create a web-based form that makes controlled access to the database possible through the workflow process.
• Setting up Accounts, Logins, Roles and Users
  Assign permissions to users through the workflow designer that complement the security of Microsoft® Windows® 2000 and Microsoft® SQL Server™.
• Scripting Workflow Events for SQL Server
  Add script to extend the capability and functionality of your workflow process.
• Creating Templates
  Store a complete workflow application in a reusable, transferable template.
• Troubleshooting Workflow Applications for SQL Server
  Find answers that help avoid or resolve the most common errors and issues you might encounter when using Workflow Designer for SQL Server.