Filter Examples
Note: The following examples use the ReadActivities Operation of the Activity Service
To accomplish this | Use this |
|---|---|
Return only activities whose Id is WS-0. | Id = 'WS-0' |
Return all activities whose id is not equal to WS-0. | Id != 'WS-0' |
Return all activities whose ObjectId is equal to 123. | ObjectId = 123 |
Only return activities whose Id begins with WS-. | Id LIKE 'WS-%' |
Return all activities whose ObjectId falls between 123 and 150, inclusively. | ObjectId BETWEEN 123 AND 150 |
Return all activities whose ObjectId is outside of the range of 0 to 123. | ObjectId NOT BETWEEN 0 AND 123 |
Return only activities that have an ObjectId of 123, 134, 152, or 165. | ObjectId IN (123, 134, 152, 165) |
Return all activities whose Id begins with WS- and whose PrimaryResourceObjectId is null. | Id LIKE 'WS-%' AND PrimaryResourceObjectId IS NULL |
Return only activities whose Id begins with WS- and whose PlannedStartDate is not null. | Id LIKE 'WS-%' AND PlannedStartDate IS NOT NULL |
Return only activities whose Id begins with WS- and whose AutoComputeActuals flag is Y. | Id LIKE 'WS-%' AND AutoComputeActuals = 'Y' |
Return only activities whose Id begins with WS- and whose PlannedLaborUnits is 0. | Id LIKE 'WS-%' AND PlannedLaborUnits= 0 |
Return only activities whose Id begins with WS- and whose PlannedLaborUnits is between 1 and 10, inclusive. | Id LIKE 'WS-%' AND (PlannedLaborUnits >= 1 AND PlannedLaborUnits <= 10) |
Return only activities whose Id begins with WS- and whose PlannedLaborUnits is greater than or equal to 0. | Id LIKE 'WS-%' AND PlannedLaborUnits >= 0 |
Return only activities whose Id begins with WS- and whose MaxActivityIdLength is not 1, 2, or 3. | Id LIKE 'WS-%' AND MaxActivityIdLength IS NOT (1, 2, or 3) |
Return only activities whose Id begins with WS- and whose LaborUnitsPercentComplete is not 0.06. | Id LIKE 'WS-%' AND LaborUnitsPercentComplete != 0.06 |
Return only activities whose Id begins with WS- and whose LaborUnitsPercentComplete is less than or equal to 85. | Id LIKE 'WS-%' AND LaborUnitsPercentComplete <= 85 |
Return only activities whose Id begins with WS- and whose EstimatedWeight is greater than or equal to 1. | Id LIKE 'WS-%' AND EstimatedWeight >= 1 |
Return only activities whose Id begins with WS- and whose AnticipatedStartDate is greater than or equal to its PlannedStartDate. | Id LIKE 'WS-%' AND AnticipatedStartDate >= PlannedStartDate |
Return only activities whose Id begins with WS- and whose PlannedStartDate is at 01/01/2003 3:30 pm. | Oracle Id LIKE 'WS-%' AND PlannedStartDate =TO_DATE('2003-01-01 15:30:00', 'yyyy-mm-dd hh24:mi:ss') SQLServer Id LIKE 'WS-%' AND PlannedStartDate =CONVERT(datetime,'2003-01-01 15:30:00',120) |
Return only activities whose Id begins with WS- and whose PlannedStartDate is less than 12/01/2003. | Oracle Id LIKE 'WS-%' AND PlannedStartDate < TO_DATE('2003-12-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') SQLServer Id LIKE 'WS-%' AND PlannedStartDate < CONVERT(datetime,'2003-12-01 00:00:00',120) |
Return only activities whose Id begins with WS- and whose PlannedStartDate is at 12/01/2003 3:30 pm. | Oracle Id LIKE 'WS-%' AND PlannedStartDate =TO_DATE('2003-12-01 15:30:00', 'yyyy-mm-dd hh24:mi:ss') SQLServer Id LIKE 'WS-%' AND PlannedStartDate =CONVERT(datetime,'2003-12-01 15:30:00',120) |
Return only activities with a ProjectObjectId of 123 and whose PlannedDuration and RemainingDuration total 100 and the RemainingDuration minus the PlannedDuration is 0. | ProjectObjectId = 123 AND PlannedDuration + RemainingDuration = 100 and RemainingDuration - PlannedDuration = 0 |
Return only activities with a ProjectObjectId of 123 and a DurationType of DT_FixedDrtn. | ProjectObjectId = 123 AND DurationType = ''Fixed Duration and Units/Time'' |
Last Published Thursday, May 2, 2024