Project Filters
Filters Syntax
Project Filters are written in SQL language and support Or/And junctions, Like operators with wildcard %, text must be enclosed in single quotes.
Possible filtering condition include:
- Status = 'Active'
- Status = 'Active' Or Status = 'Planned'
- (Status = 'Active' Or Status = 'Planned') And Name Like '%PartOfTheName%'
List of Project Fields Available in Filters
|
ActivityDefaultActivityType |
|
ActivityDefaultCalendarObjectId |
|
ActivityDefaultCostAccountObjectId |
|
ActivityDefaultDurationType |
|
ActivityDefaultPercentCompleteType |
|
ActivityDefaultPricePerUnit |
|
ActivityIdBasedOnSelectedActivity |
|
ActivityIdIncrement |
|
ActivityIdPrefix |
|
ActivityIdSuffix |
|
ActivityPercentCompleteBasedOnActivitySteps |
|
AddActualToRemaining |
|
AddedBy |
|
AllowNegativeActualUnitsFlag |
|
AnnualDiscountRate |
|
AnticipatedFinishDate |
|
AnticipatedStartDate |
|
AssignmentDefaultDrivingFlag |
|
AssignmentDefaultRateType |
|
CheckOutDate |
|
CheckOutStatus |
|
CheckOutUserObjectId |
|
ContainsSummaryData |
|
ContractManagementGroupName |
|
ContractManagementProjectName |
|
CostQuantityRecalculateFlag |
|
CreateDate |
|
CreateUser |
|
CriticalActivityFloatLimit |
|
CriticalActivityPathType |
|
CurrentBaselineProjectObjectId |
|
CurrentBudget |
|
CurrentVariance |
|
DataDate |
|
DateAdded |
|
DefaultPriceTimeUnits |
|
Description |
|
DiscountApplicationPeriod |
|
DistributedCurrentBudget |
|
EarnedValueComputeType |
|
EarnedValueETCComputeType |
|
EarnedValueETCUserValue |
|
EarnedValueUserPercent |
|
EnablePublication |
|
EnableSummarization |
|
FinishDate |
|
FiscalYearStartMonth |
|
ForecastFinishDate |
|
ForecastStartDate |
|
GUID |
|
HasFutureBucketData |
|
Id |
|
IndependentETCLaborUnits |
|
IndependentETCTotalCost |
|
IntegratedType |
|
IsTemplate |
|
LastApplyActualsDate |
|
LastFinancialPeriodObjectId |
|
LastLevelDate |
|
LastPublishedOn |
|
LastScheduleDate |
|
LastSummarizedDate |
|
LastUpdateDate |
|
LastUpdateUser |
|
LevelingPriority |
|
LinkActualToActualThisPeriod |
|
LinkPercentCompleteWithActual |
|
LinkPlannedAndAtCompletionFlag |
|
MustFinishByDate |
|
Name |
|
NetPresentValue |
|
OBSName |
|
OBSObjectId |
|
ObjectId |
|
OriginalBudget |
|
OverallProjectScore |
|
OwnerResourceObjectId |
|
ParentEPSObjectId |
|
PaybackPeriod |
|
PlannedStartDate |
|
PrimaryResourcesCanMarkActivitiesAsCompleted |
|
ProjectForecastStartDate |
|
ProposedBudget |
|
PublicationPriority |
|
ResetPlannedToRemainingFlag |
|
ResourceCanBeAssignedToSameActivityMoreThanOnce |
|
ResourcesCanAssignThemselvesToActivities |
|
ResourcesCanEditAssignmentPercentComplete |
|
ResourcesCanMarkAssignmentAsCompleted |
|
ResourcesCanViewInactiveActivities |
|
ReturnOnInvestment |
|
RiskExposure |
|
RiskLevel |
|
RiskMatrixObjectId |
|
RiskScore |
|
ScheduledFinishDate |
|
SourceProjectObjectId |
|
StartDate |
|
Status |
|
StrategicPriority |
|
SummarizeToWBSLevel |
|
SummarizedDataDate |
|
SummaryAccountingVarianceByCost |
|
SummaryAccountingVarianceByLaborUnits |
|
SummaryActivityCount |
|
SummaryActualDuration |
|
SummaryActualExpenseCost |
|
SummaryActualFinishDate |
|
SummaryActualLaborCost |
|
SummaryActualLaborUnits |
|
SummaryActualMaterialCost |
|
SummaryActualNonLaborCost |
|
SummaryActualNonLaborUnits |
|
SummaryActualStartDate |
|
SummaryActualThisPeriodCost |
|
SummaryActualThisPeriodLaborCost |
|
SummaryActualThisPeriodLaborUnits |
|
SummaryActualThisPeriodMaterialCost |
|
SummaryActualThisPeriodNonLaborCost |
|
SummaryActualThisPeriodNonLaborUnits |
|
SummaryActualTotalCost |
|
SummaryActualValueByCost |
|
SummaryActualValueByLaborUnits |
|
SummaryAtCompletionDuration |
|
SummaryAtCompletionExpenseCost |
|
SummaryAtCompletionLaborCost |
|
SummaryAtCompletionLaborUnits |
|
SummaryAtCompletionMaterialCost |
|
SummaryAtCompletionNonLaborCost |
|
SummaryAtCompletionNonLaborUnits |
|
SummaryAtCompletionTotalCost |
|
SummaryAtCompletionTotalCostVariance |
|
SummaryBaselineCompletedActivityCount |
|
SummaryBaselineDuration |
|
SummaryBaselineExpenseCost |
|
SummaryBaselineFinishDate |
|
SummaryBaselineInProgressActivityCount |
|
SummaryBaselineLaborCost |
|
SummaryBaselineLaborUnits |
|
SummaryBaselineMaterialCost |
|
SummaryBaselineNonLaborCost |
|
SummaryBaselineNonLaborUnits |
|
SummaryBaselineNotStartedActivityCount |
|
SummaryBaselineStartDate |
|
SummaryBaselineTotalCost |
|
SummaryBudgetAtCompletionByCost |
|
SummaryBudgetAtCompletionByLaborUnits |
|
SummaryCompletedActivityCount |
|
SummaryCostPercentComplete |
|
SummaryCostPercentOfPlanned |
|
SummaryCostPerformanceIndexByCost |
|
SummaryCostPerformanceIndexByLaborUnits |
|
SummaryCostVarianceByCost |
|
SummaryCostVarianceByLaborUnits |
|
SummaryCostVarianceIndex |
|
SummaryCostVarianceIndexByCost |
|
SummaryCostVarianceIndexByLaborUnits |
|
SummaryDurationPercentComplete |
|
SummaryDurationPercentOfPlanned |
|
SummaryDurationVariance |
|
SummaryEarnedValueByCost |
|
SummaryEarnedValueByLaborUnits |
|
SummaryEstimateAtCompletionByCost |
|
SummaryEstimateAtCompletionByLaborUnits |
|
SummaryEstimateAtCompletionHighPercentByLaborUnits |
|
SummaryEstimateAtCompletionLowPercentByLaborUnits |
|
SummaryEstimateToCompleteByCost |
|
SummaryEstimateToCompleteByLaborUnits |
|
SummaryExpenseCostPercentComplete |
|
SummaryExpenseCostVariance |
|
SummaryFinishDateVariance |
|
SummaryInProgressActivityCount |
|
SummaryLaborCostPercentComplete |
|
SummaryLaborCostVariance |
|
SummaryLaborUnitsPercentComplete |
|
SummaryLaborUnitsVariance |
|
SummaryLevel |
|
SummaryMaterialCostPercentComplete |
|
SummaryMaterialCostVariance |
|
SummaryNonLaborCostPercentComplete |
|
SummaryNonLaborCostVariance |
|
SummaryNonLaborUnitsPercentComplete |
|
SummaryNonLaborUnitsVariance |
|
SummaryNotStartedActivityCount |
|
SummaryPerformancePercentCompleteByCost |
|
SummaryPerformancePercentCompleteByLaborUnits |
|
SummaryPlannedCost |
|
SummaryPlannedDuration |
|
SummaryPlannedExpenseCost |
|
SummaryPlannedFinishDate |
|
SummaryPlannedLaborCost |
|
SummaryPlannedLaborUnits |
|
SummaryPlannedMaterialCost |
|
SummaryPlannedNonLaborCost |
|
SummaryPlannedNonLaborUnits |
|
SummaryPlannedStartDate |
|
SummaryPlannedValueByCost |
|
SummaryPlannedValueByLaborUnits |
|
SummaryProgressFinishDate |
|
SummaryRemainingDuration |
|
SummaryRemainingExpenseCost |
|
SummaryRemainingFinishDate |
|
SummaryRemainingLaborCost |
|
SummaryRemainingLaborUnits |
|
SummaryRemainingMaterialCost |
|
SummaryRemainingNonLaborCost |
|
SummaryRemainingNonLaborUnits |
|
SummaryRemainingStartDate |
|
SummaryRemainingTotalCost |
|
SummarySchedulePercentComplete |
|
SummarySchedulePercentCompleteByLaborUnits |
|
SummarySchedulePerformanceIndexByCost |
|
SummarySchedulePerformanceIndexByLaborUnits |
|
SummaryScheduleVarianceByCost |
|
SummaryScheduleVarianceByLaborUnits |
|
SummaryScheduleVarianceIndex |
|
SummaryScheduleVarianceIndexByCost |
|
SummaryScheduleVarianceIndexByLaborUnits |
|
SummaryStartDateVariance |
|
SummaryToCompletePerformanceIndexByCost |
|
SummaryTotalCostVariance |
|
SummaryTotalFloat |
|
SummaryUnitsPercentComplete |
|
SummaryVarianceAtCompletionByLaborUnits |
|
TotalBenefitPlan |
|
TotalBenefitPlanTally |
|
TotalFunding |
|
TotalSpendingPlan |
|
TotalSpendingPlanTally |
|
UnallocatedBudget |
|
UndistributedCurrentVariance |
|
UseProjectBaselineForEarnedValue |
|
WBSCodeSeparator |
|
WBSMilestonePercentComplete |
|
WBSObjectId |
|
WebSiteRootDirectory |
|
WebSiteURL |
|
|
|
|
|
Reading this list to the end of the page can be bad for your health, but If you want to know the Activity name mapping by heart as well, it's available here. |
