Skip to main content

 

Planview Customer Success Center

Why do my reports not return values for user with a different language?

Using Query Items returning localized language specific values in a filter need to use the GetCultureText function to be compatible with the different user languages available in Daptiv.

For example, the below filter will only work if the user running the report has their culture setting set to English:

[Presentation].[Users].[Status] = 'Active'

The filter needs to use the GetCultureText function with the appropriate key:

[Presentation].[Users].[Status] = GetCultureText ([Relational View].[CultureShort];'EnterpriseMemberStatus_Active')

 

Below is a list of most commonly used query items and their associated keys. Please contact Customer Care if you need additional assistance.

[Projects].[Project Status]
GetCultureText ([Relational View].[CultureShort],'PublicObjectStatus_Active')
GetCultureText ([Relational View].[CultureShort],'PublicObjectStatus_Archived')
GetCultureText ([Relational View].[CultureShort],'PublicObjectStatus_None')

[Projects].[Summary]
[Project History].[Summary]
GetCultureText ([Relational View].[CultureShort],Value_InformationNotProvided')

[Projects].[Phase]
GetCultureText([Relational View].[CultureShort],'StandardPhases_CloseOut')
GetCultureText([Relational View].[CultureShort],'StandardPhases_Concept')
GetCultureText([Relational View].[CultureShort],'StandardPhases_Execution')
GetCultureText([Relational View].[CultureShort],'StandardPhases_Initiation')
GetCultureText([Relational View].[CultureShort],'StandardPhases_Planning')

For:
[Projects].[Project Start Quarter]
[Projects].[Project Start Quarter]
[Projects].[Schedule Start Quarter]
[Projects].[Schedule Finish Quarter]
[Project Request].[Project Start Quarter]
[Project Request].[Project End Quarter]
[Project Request].[Schedule Start Quarter]
[Task].[Task Planned Start Quarter]
[Task].[Task Planned Finish Quarter]
[Task].[Task Actual Start Quarter]
[Task].[Task Actual Finish Quarter]
[Task].[Quarter]
[Task Actual Work].[Quarter]
[Baseline Task].[Baseline Planned Start Quarter]
[Baseline Task].[Baseline Planned Finish Quarter]
[Nonworking Time Schedule].[User Calendar Quarter]
[Project Member].[User Calendar Quarter]
[Timesheets].[Timesheet Start Quarter]
[Task Work Entries].[Work Entry Quarter]
[Work Entries].[Work Entry Quarter]
[Requirements].[Resource Quarter]
, use: GetCultureText ([Relational View].[CultureShort],'QuarterPrefix')

[Projects].[Priority]
[Project Request].[Priority]
(Recommend using [Projects].[Priority (numeric)] in filters with values 0,1,2,3,4)
GetCultureText ([Relational View].[CultureShort],'WorkspacePriority_Low')
GetCultureText ([Relational View].[CultureShort],'WorkspacePriority_MediumLow')
GetCultureText ([Relational View].[CultureShort],'WorkspacePriority_Medium')
GetCultureText ([Relational View].[CultureShort],'WorkspacePriority_MediumHigh')
GetCultureText ([Relational View].[CultureShort],'WorkspacePriority_High')

[Projects].[Health]
[Project History].[Health]
[Project Request].[Health]
(Recommend using [Projects].[Health (numeric)] in filters with values 0,1,2)
GetCultureText ([Relational View].[CultureShort],'WorkspaceHealth_OnPlan')
GetCultureText ([Relational View].[CultureShort],'WorkspaceHealth_NeedsAttention')
GetCultureText ([Relational View].[CultureShort],'WorkspaceHealth_InTrouble')
GetCultureText ([Relational View].[CultureShort],'WorkspaceHealth_Unknown')

[Projects].[State]
[Project History].[State]
[Project Request].[State]
(Recommend using [Projects].[State (numeric)] in filters with values 0,1,2,3,4,5)
GetCultureText ([Relational View].[CultureShort],'ProjectState_Request')
GetCultureText ([Relational View].[CultureShort],'ProjectState_NotStarted')
GetCultureText ([Relational View].[CultureShort],'ProjectState_InProgress')
GetCultureText ([Relational View].[CultureShort],'ProjectState_OnHold')
GetCultureText ([Relational View].[CultureShort],'ProjectState_Completed')
GetCultureText ([Relational View].[CultureShort],'ProjectState_Cancelled')

[Projects].[Approval Status]
[Project History].[Approval History Status]
[Project Request].[Approval Status]
[Timesheets].[Approval Status]
[Documents].[Approval Status]
(Recommend using [Projects].[Approval Status (numeric)] in filters with values 0,1,2,3,4)
GetCultureText ([Relational View].[CultureShort],'ApprovalStatus_Pending')
GetCultureText ([Relational View].[CultureShort],'ApprovalStatus_Approved')
GetCultureText ([Relational View].[CultureShort],'ApprovalStatus_Declined')
GetCultureText ([Relational View].[CultureShort],'ApprovalStatus_NotRequired')
GetCultureText ([Relational View].[CultureShort],'ApprovalStatus_Overridden')

[Projects].[Capacity]
[Project History].[Capacity]
[Project Request].[Capacity]
GetCultureText ([Relational View].[CultureShort],'Capacity_Unplanned')
GetCultureText ([Relational View].[CultureShort],'Capacity_Planned')

[Projects].[Parent Project Name]
GetCultureText ([Relational View].[CultureShort],'Value_None')

[Projects].[Schedule Lock Type]
[Project Request].[Schedule Lock Type]
(Recommend using [Projects].[Schedule Lock Type (numeric)] in filters with values 0,1,2,3,4)
GetCultureText ([Relational View].[CultureShort],'ScheduleLockType_Unlocked')
GetCultureText ([Relational View].[CultureShort],'ScheduleLockType_Session')
GetCultureText ([Relational View].[CultureShort],'ScheduleLockType_Indefinite')
GetCultureText ([Relational View].[CultureShort],'ScheduleLockType_Offline')
GetCultureText ([Relational View].[CultureShort],'ScheduleLockType_Integration')

[Project History].[Project History Status]
GetCultureText ([Relational View].[CultureShort],'PublicObjectStatus_Active')
GetCultureText ([Relational View].[CultureShort],'PublicObjectStatus_Archived')
GetCultureText ([Relational View].[CultureShort],'PublicObjectStatus_None')

[Task].[Priority]
(Recommend using [Task].[Priority (numeric)] in filters with values 0,1,2)
GetCultureText ([Relational View].[CultureShort],'TaskPriority_Low')
GetCultureText ([Relational View].[CultureShort],'TaskPriority_Medium')
GetCultureText ([Relational View].[CultureShort],'TaskPriority_High')

[Task].[Task Status]
GetCultureText ([Relational View].[CultureShort],'TaskStatus_Complete')
GetCultureText ([Relational View].[CultureShort],'TaskStatus_OnHold')
GetCultureText ([Relational View].[CultureShort],'TaskStatus_Overdue')
GetCultureText ([Relational View].[CultureShort],'TaskStatus_InProgress')
GetCultureText ([Relational View].[CultureShort],'TaskStatus_NotStarted')

[Task].[Current Weekly Status]
GetCultureText ([Relational View].[CultureShort],'TaskWeeklyStatus_Overdue')
GetCultureText ([Relational View].[CultureShort],'TaskWeeklyStatus_Due')
GetCultureText ([Relational View].[CultureShort],'TaskWeeklyStatus_DueNext')
GetCultureText ([Relational View].[CultureShort],'TaskWeeklyStatus_Completed')
GetCultureText ([Relational View].[CultureShort],'TaskWeeklyStatus_OnTarget')

For:
[Task].[On Hold]
[Task].[IsParentTask]
[Task].[Is Billable]
[Task].[Is Restricted]
[Task].[Effort Driven]
[Task].[Deliverable]
[Task].[Milestone]
[Task].[Is Manual Internal Billing Rate]
[Task].[Is Manual External Billing Rate]
[Task Dependency].[Is Cross Project]
[Users].[Timesheets Required]
[Users].[Is Manual Internal Billing Rate]
[Users].[Is Manual External Billing Rate]
[Project Member].[Timesheets Required]
[Project Member].[Is Manual Internal Billing Rate]
[Project Member].[Is Manual External Billing Rate]
[Timesheet Tasks].[Is Billable]
[Task Work Entries].[Is Work Entry Approved]
[Task Work Entries].[Is Non-Project Work]
[Work Entries].[Is Work Entry Approved]
[Discussion].[Closed]
[News].[Is Restricted]
[Issues].[Is Restricted]
[Appointments].[Is Recurring]
[Appointments].[All Day]
[Appointments].[Request Acceptance]
[Appointments].[Is Restricted]
[Appointments].[Poll Closed Manually]
[Polls].[Has Voted]
[Polls].[Can Vote]
[Polls].[Can View Results]
[Polls].[Can View Others]
[Documents].[Is Locked]
[Documents].[Is Restricted]
[Document History].[Is Restricted]
[Requirements].[Requirement Resource Type Active]
, use: GetCultureText ([Relational View].[CultureShort],'Boolean_No'), or GetCultureText ([Relational View].[CultureShort],'Boolean_Yes')

[Task].[Task Type]
GetCultureText ([Relational View].[CultureShort],'TaskType_FixedUnits')
GetCultureText ([Relational View].[CultureShort],'TaskType_FixedDuration')
GetCultureText ([Relational View].[CultureShort],'TaskType_FixedWork')

[Task].[Constraint Type]
(Recommend using [Projects].[Constraint Type (numeric)] in filters with values 0,1,2,3,4,5,6,7,8)
GetCultureText ([Relational View].[CultureShort],'TaskConstraintType_None')
GetCultureText ([Relational View].[CultureShort],'TaskConstraintType_MustFinishOn')
GetCultureText ([Relational View].[CultureShort],'TaskConstraintType_MustStartOn')
GetCultureText ([Relational View].[CultureShort],'TaskConstraintType_AsSoonAsPossible')
GetCultureText ([Relational View].[CultureShort],'TaskConstraintType_AsLateAsPossible')
GetCultureText ([Relational View].[CultureShort],'TaskConstraintType_FinishNoEarlierThan')
GetCultureText ([Relational View].[CultureShort],'TaskConstraintType_FinishNoLaterThan')
GetCultureText ([Relational View].[CultureShort],'TaskConstraintType_StartNoEarlierThan')
GetCultureText ([Relational View].[CultureShort],'TaskConstraintType_StartNoLaterThan')

[Task].[Assignee Full Name]
GetCultureText ([Relational View].[CultureShort],'TaskAssigneeStatus_Unassigned')

[Task].[Task Internal Billing Rate Inherited From]
GetCultureText ([Relational View].[CultureShort],'BillingRateSource_WorkspaceMember')
GetCultureText ([Relational View].[CultureShort],'BillingRateSource_EnterpriseMember')
GetCultureText ([Relational View].[CultureShort],'BillingRateSource_ResourceType')

[Task].[Task External Billing Rate Inherited From]
GetCultureText ([Relational View].[CultureShort],'BillingRateSource_TaskItem')
GetCultureText ([Relational View].[CultureShort],'BillingRateSource_WorkspaceMember')
GetCultureText ([Relational View].[CultureShort],'BillingRateSource_EnterpriseMember')
GetCultureText ([Relational View].[CultureShort],'BillingRateSource_ResourceType')

[Task Planned Work].[Resource Type Name]
[Task Planned Work].[Resource Type Description]
[Task Actual Work].[Resource Type Name]
[Users].[Resource Type Name]
[Project Member].[Resource Type Name]
[Requirements].[Requirement Resource Type Name]
GetCultureText ([Relational View].[CultureShort],ResourceType_Inactive')

[Task Dependency].[Dependency]
GetCultureText ([Relational View].[CultureShort],'TaskDependency_Predecessor')
GetCultureText ([Relational View].[CultureShort],'TaskDependency_Successor')

[Task Dependency].[Dependency Type]
GetCultureText ([Relational View].[CultureShort],'TaskDependencyType_FinishToStart')
GetCultureText ([Relational View].[CultureShort],'TaskDependencyType_StartToStart')
GetCultureText ([Relational View].[CultureShort],'TaskDependencyType_StartToFinish')
GetCultureText ([Relational View].[CultureShort],'TaskDependencyType_FinishToFinish')

[Users].[Report Author License]
[Project Member].[Report Author License]
GetCultureText ([Relational View].[CultureShort],'License_BusinessAuthor')
GetCultureText ([Relational View].[CultureShort],'License_ProfessionalAuthor')
GetCultureText ([Relational View].[CultureShort],'License_None')

[Users].[User Internal Billing Rate Inherited From]
[Users].[User External Billing Rate Inherited From]
[Project Member].[Member Internal Billing Rate Inherited From]
[Project Member].[Member External Billing Rate Inherited From]
GetCultureText ([Relational View].[CultureShort],'BillingRateSource_EnterpriseMember')
GetCultureText ([Relational View].[CultureShort],'BillingRateSource_ResourceType')

[Users].[Status]
[Project Member].[Member Status]
GetCultureText ([Relational View].[CultureShort],'EnterpriseMemberStatus_Inactive')
GetCultureText ([Relational View].[CultureShort],'EnterpriseMemberStatus_Active')

[Nonworking Time Schedule].[Nonworking Time Duration]
GetCultureText ([Relational View].[CultureShort],'TimeDuration_AllDay')
GetCultureText ([Relational View].[CultureShort],'TimeDuration_HoursPerDay')

[Nonworking Time Schedule].[Nonworking Time Type]
[Project Member].[Nonworking Time Type]
[Member Resources].[Nonworking Time Type]
GetCultureText ([Relational View].[CultureShort],'WorkCalendarExclusionType_Personal')
GetCultureText ([Relational View].[CultureShort],'WorkCalendarExclusionType_Global')

[Workgroups].[Workgroup Type]
GetCultureText ([Relational View].[CultureShort],'WorkgroupType_Enterprise')
GetCultureText ([Relational View].[CultureShort],'WorkgroupType_Workspace')

[Timesheets].[Timesheet Period]
GetCultureText ([Relational View].[CultureShort],'TimeDuration_To')

[Timesheets].[Timesheet Status]
GetCultureText ([Relational View].[CultureShort],'TimesheetStateFlags_Open')
GetCultureText ([Relational View].[CultureShort],'TimesheetStateFlags_Closed')

[Timesheets].[Approval Type]
GetCultureText ([Relational View].[CultureShort],'TimesheetApprovalType_Request')
GetCultureText ([Relational View].[CultureShort],'TimesheetApprovalType_Action')

[Timesheet Tasks].[Priority]
GetCultureText ([Relational View].[CultureShort],'TaskPriority_Low')
GetCultureText ([Relational View].[CultureShort],'TaskPriority_Medium')
GetCultureText ([Relational View].[CultureShort],'TaskPriority_High')

[Timesheet Tasks].[Task Status]
GetCultureText ([Relational View].[CultureShort],'TaskStatus_Overdue')
GetCultureText ([Relational View].[CultureShort],'TaskStatus_InProgress')
GetCultureText ([Relational View].[CultureShort],'TaskStatus_NotStarted')
GetCultureText ([Relational View].[CultureShort],'TaskStatus_Complete')

[Timesheet Tasks].[Current Weekly Status]
GetCultureText ([Relational View].[CultureShort],'TaskWeeklyStatus_Overdue')
GetCultureText ([Relational View].[CultureShort],'TaskWeeklyStatus_Due')
GetCultureText ([Relational View].[CultureShort],'TaskWeeklyStatus_DueNext')
GetCultureText ([Relational View].[CultureShort],'TaskWeeklyStatus_Completed')
GetCultureText ([Relational View].[CultureShort],'TaskWeeklyStatus_OnTarget')

[Task Work Entries].[Project Name]
GetCultureText ([Relational View].[CultureShort],'WorkEntryType_NonProject')

[Task Work Entries].[Project Type]
GetCultureText ([Relational View].[CultureShort],'WorkEntryType_NonProject')

[Work Entries].[Is Work Entry Approved]
[Work Entries].[WorkType]
GetCultureText ([Relational View].[CultureShort],'WorkEntryType_NonProject')
GetCultureText ([Relational View].[CultureShort],'WorkEntryType_Project')
GetCultureText ([Relational View].[CultureShort],'WorkEntryType_Task')

[Discussion].[Discussion Type]
GetCultureText ([Relational View].[CultureShort],'DiscussionType_FYI')
GetCultureText ([Relational View].[CultureShort],'DiscussionType_Question')
GetCultureText ([Relational View].[CultureShort],'DiscussionType_Answer')
GetCultureText ([Relational View].[CultureShort],'DiscussionType_DiscussionItem')

[News].[Priority]
GetCultureText ([Relational View].[CultureShort],'NewsItemPriority_High')
GetCultureText ([Relational View].[CultureShort],'NewsItemPriority_Medium')
GetCultureText ([Relational View].[CultureShort],'NewsItemPriority_Low')

[Issues].[Issue Current Status]
GetCultureText ([Relational View].[CultureShort],'IssueItemStatus_NotStarted')
GetCultureText ([Relational View].[CultureShort],'IssueItemStatus_InProgress')
GetCultureText ([Relational View].[CultureShort],'IssueItemStatus_Complete')
GetCultureText ([Relational View].[CultureShort],'IssueItemStatus_Overdue')
GetCultureText ([Relational View].[CultureShort],'IssueItemStatus_DueToday')

[Issues].[Priority]
GetCultureText ([Relational View].[CultureShort],'IssueItemPriority_High')
GetCultureText ([Relational View].[CultureShort],'IssueItemPriority_Medium')
GetCultureText ([Relational View].[CultureShort],'IssueItemPriority_Low')

[Appointments].[Recurrence Type]
GetCultureText ([Relational View].[CultureShort],'AppointmentItemRecurrenceType_Daily')
GetCultureText ([Relational View].[CultureShort],'AppointmentItemRecurrenceType_Weekly')
GetCultureText ([Relational View].[CultureShort],'AppointmentItemRecurrenceType_Monthly')
GetCultureText ([Relational View].[CultureShort],'AppointmentItemRecurrenceType_Yearly')

[Appointments].[Response Status]
GetCultureText ([Relational View].[CultureShort],'ItemAssignmentResponseStatus_NotResponded')
GetCultureText ([Relational View].[CultureShort],'ItemAssignmentResponseStatus_Accepted')
GetCultureText ([Relational View].[CultureShort],'ItemAssignmentResponseStatus_Declined')
GetCultureText ([Relational View].[CultureShort],'ItemAssignmentResponseStatus_CannotDecline')

[Requirements].[Status]
GetCultureText ([Relational View].[CultureShort],'ResourceRequirementStatus_Filled')
GetCultureText ([Relational View].[CultureShort],'ResourceRequirementStatus_Open')

[Allocations].[Status]
GetCultureText ([Relational View].[CultureShort],'ResourceAllocation_Approved')
GetCultureText ([Relational View].[CultureShort],'ResourceAllocation_Pending')