Skip to main content
LinkedIn
Copied!

Table of Contents

Work item reports

Version:

Only available versions of this content are shown in the dropdown

Standard reports on work items are based on the exposed columns in the schema of the pc_work table for work items, and the pc_history_work table for history instances for work items.

Work items are stored in the pc_work table, and work item history instances are stored in the pc_history_work table. This relationship is defined by the two database table instances Work- and History-Work-.

When you create new work types and corresponding work history classes using the Application Accelerator, the system maps the new work classes appropriately into these two tables.

However, when you create a concrete class by using the Class form, the default mapping is to the pr_other table (and the pr_history table, for history). These mappings are not appropriate for work items and may cause SQL errors or JavaScript failures. You can remedy this by adding the two appropriate database table instances.

Two standard database views are linked to the Data-Assignment-Summary and Data-Assignment-WBSummary classes. These support custom worklist and assignment reporting. Update these view definitions if you use these views and you change or copy the pc_work table.

Did you find this content helpful?

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us