List objects with a pending approval process using a certain status

If you try to delete a status, an error message might tell you that it can’t be deleted because it’s in at least one pending approval process in your system. You can run a report to list the objects where it is in an pending approval process, then decide what you need to do for each one.

Access requirements

Expand to view access requirements for the functionality in this article.

You must have the following access to perform the steps in this article:

table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header
Adobe Workfront plan Any
Adobe Workfront license

New: Standard

or

Current: Plan

Access level configurations

Edit access to Reports, Dashboards, Calendars

Edit access to Filters, Views, Groupings

Object permissions You obtain Manage permissions to the reports you create.

For more detail about the information in this table, see Access requirements in Workfront documentation.

In Standard Mode

  1. Click the Main Menu icon Main Menu in the upper-right corner of Adobe Workfront, or (if available), click the Main Menu icon Main Menu in the upper-left corner, then click Reports.

  2. Click New Report, then select Project Report, Task Report, or Issue Report.

  3. Open the Filters tab.

  4. Click Add a Filter Rule, then do the following to set up the rule:

    1. Start typing status, then select Status when it displays.
    2. Leave Equal in the second field.
    3. Select the name of the status in the third field.
  5. Click Add a Filter Rule again, then do the following to set up the rule

    1. Start typing pending status, then select that item when it displays under the object type where you are looking (Project, Task, or Issue).
    2. Leave Equal in the second field.
    3. Type in in the third field.
  6. Click Add a Filter Rule again, then do the following to set up the rule

    1. Start typing approval process, then select Group ID when it displays under Approval Process.
    2. Select Is Blank in the second field.
  7. Click Save + Close to run the report and list any objects of the type you specified with approval processes in pending state based on the status you specified (Project, Task, or Issue).

  8. Repeat these steps to find the same information for the other two object types.

In Text Mode

  1. Click the Main Menu icon Main Menu in the upper-right corner of Adobe Workfront, or (if available), click the Main Menu icon Main Menu in the upper-left corner, then click Reports.

  2. Click New Report, then select Project Report, Task Report, or Issue Report.

  3. Open the Filters tab.

  4. Select Switch to Text Mode.

  5. Copy and paste the following into the editing window, replacing XXX with the 3-letter key for the status:

    status=XXX

    status_Mod=in

    approvalProcess:groupID_Mod=isblank

    You can view the key in the list of statuses, as shown in these articles:

  6. Click Save + Close to run the report and list any objects of the type you specified with approval processes in pending state based on the status you specified (Project, Task, or Issue).

  7. Repeat these steps to find the same information for the other two object types.

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43