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 IsCritical flag is Y.
|
Id LIKE 'WS-%' AND IsCritical = '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''
|