Project Issue List

This article provides all the Fields available for each View currently available under the Project Issue List Data Source in Upland Analytics.

The following Views are available when Project Issue List Data Source is selected upon creating a report. Click on any of them to view the available Fields.

Issue Owners
Issue Reported By
Project
Project Issue
User - Issue Created By
User - Issue Modified By

Issue Owners

Field Name	Description	Type
Issue Id	This is the Id of the issue.	A
Owner Id	This is the Id of the owner.	A

 

Issue Reported By

Field Name	Description	Type
Email	This is the email address of the reporter.	A
First Name	This is the first name of the reporter.	A
Last Name	This is the Last name of the reporter.	A
Name (URL)	This is the URL link to the issue.	A
Resource Id	This is the resource Id of the reporter.	A
Status	This is the status of the reporter.	A

 

Project

Field Name	Description	Type
Business Priority	This is the project business priority.	A
Category	This is the project category.	A
Category Sort Order	This is the project category sort order.	A
Created By	Project creator ID.	A
Created Date	The date the Project was created, formatted as mm/dd/yyyy with a timestamp.
Created Date Date	The date the Project was created, formatted as mm/dd/yyyy without a timestamp.
Created Date Month Year	The month and the year the Project was created.
Created Date Quarter Year	The fiscal quarter and the year the Project was created.
Created Date Year	The year the Project was created.
Created Date Week	The week the Project was created.
Description	This is the project description.	A
Last Status Update	This is the date and time of the project's last status update.
Modified By	This is the project modifier.	A
Modified Date	The date the Project was last modified, formatted as mm/dd/yyyy with a timestamp.
Modified Date Date	The date the Project was last modified, formatted as mm/dd/yyyy without a timestamp.
Modified Date Month Year	The month and the year the Project was last modified.
Modified Date Quarter Year	The fiscal quarter and the year the Project was last modified.
Modified Date Year	The year the Project was last modified.
Modified Date Week	The week the Project was last modified.
Name (Text)	This is the project name.	A
Name (URL)	This is the project name. It links directly to the project summary page.	A
Number	This is the project number.	A
Operations	This is the project operation.	A
Organization Owner	This is the project organization owner.	A
Owner Id	This is the Id of the owner.	A
Portfolio	This is the name of the portfolio associated to the project.	A
Priority	This is the project priority.	A
Priority Sort Order	This is the project priority sort order.	A
Program	This is the name of the program.	A
Project Id	This is the ID number of the project.	A
Project Status Id	This is the ID number of the project's current status.
Status	This is the current project status.
Status Id	This is the ID number of the project's current status.	A
Status Sort Order	This is the where the project's current status is listed in the status sort order.	A
Status Type	This is the project status type.	A
Status Type Id	This is the ID number of the project's status type.	A
Status Update	This is the project's most recent status update. Note that this could take up a lot of space in the report.	A
Type	This is the project's type.	A

 

Project Issue

Field Name	Description	Type
Subject	This is the project issue subject.	A
Action Required	This is the action required on the project issue.	A
Actual Resolution Date	This is the actual resolution date.	A
Created By	This is the issue creator ID	A
Created Date	This is the issue creation date.
Date Reported	This is the date the issue is reported.
Description	This is the description of the issue.	A
External Id	This is the external id of the issue.	A
Impact	This is the impact of the issue.	A
Impact Description	This is the issue impact description.	A
Issue Id	This is the issue id.	A
Modified By	This is the issue modifier.	A
Modified Date	This is the issue modification date.
Planned Resolution Date	This is the issue planned resolution date.
Project Id	This is the Id of the project.	A
Program Name (URL)	This is the URL link to the program issue.	A
Project Status Id	This is the project status Id.	A
Project Status Type Id	This is the project status type Id of the project.	A
Reported By	This is the Issue reporter.	A
Severity	This is the issue severity.	A
Status	This is the Issue status.	A
Status Id	This is the issue status Id.	A
Status Type	This is the issue type.	A
Status Type Id	This is the issue status type Id.	A
Status Update	This is the issue status update.	A
Subject (URL)	This is the URL link to the subject issue.	A
Type	This is the issue type.	A

 

User - Issue Created By

Field Name	Description	Type
Account Type	This is the creator account type.	A
Email	This is the email address of the creator.	A
First Name	This is the creator first name.	A
Is Active	This defines whether the creator is active.	A
Last Name	This is the creator last name.	A
Login	This is the name of the logged in creator.	A
Name (URL)	This is the URL to the issue creator.	A
User Id	This is the Id of the user.	A

 

User - Issue Modified By

Field Name	Description	Type
Account Type	This is the modifier account type.	A
Email	This is the email address of the modifier.	A
First Name	This is the modifier first name.	A
Is Active	This defines whether the modifier is active.	A
Last Name	This is the modifier last name.	A
Login	This is the name of the logged in issue modifier.	A
Name (URL)	This is the URL of the modifier.	A
User Id	This is the Id of the user.	A