Filter conditions

Returns results that do not match the specified value, for example, "Project Risk Is Not Low".

Returns results that include any of the specified values, for example, use this condition to find projects in Buenos Aires, London, or San Francisco.

Returns results that do not include any of the specified values. For example, use this condition to find projects in all locations except London.

Returns results that include any value in the specified field.

Returns results that do not include any value in the specified field. For example, use this condition to find projects that are missing values in required fields.

Returns results that include date values in the selected time period. For example, use this condition to find projects that are due in the next seven days, or to find projects that were approved in the previous year.

Returns results that include values within a specified date or financial range, including the end-points of the range.

In this date example, "Actual Start Date Between Inclusive 1/1/22 and 3/3/22" returns any project that has a start date within the range of 1/1/22 and 3/3/22, including 1/1/22 or 3/3/22.

In this financial example, "Hard Savings (Final) Between Inclusive 1 and 30,000" returns any project that has final hard savings within the range of $1 and $30,000, including $1 or $30,000.

Returns results that include values within a specified date or financial range, not including the end-points of the range.

In this date example, "Actual Start Date Between Exclusive 1/1/22 and 3/3/22" returns any project that has a start date within the range of 1/1/22 and 3/3/22, but not including 1/1/22 or 3/3/22.

In this financial example, "Hard Savings (Final) Between Exclusive 1 and 30,000" returns any project that has final hard savings within the range of $1 and $30,000, but not including $1 or $30,000.

Returns results that include the specified value for the specified field. For example, "Project Name Contains Defect" returns Defective Parts, Defects on Paper Line 6, and Reducing Defects.

Returns results that do not include the specified value for the specified field. For example, "Project Name Does Not Contain Defect" returns projects that do not include Defect in their names.

Returns results where the specified field starts with the specified value. For example, "Project Name Starts With Defect" returns Defective Parts and Defects on Paper Line 6, but not Reducing Defects.

Returns results where the specified field ends with the specified value. For example, "Project Name Ends With Reduction" returns Repackaging Reduction, Grinding Disc Scrap Reduction, and Syringe Molding Waste Reduction, but not Reduction on Line 8.

Returns results that are less than the specified value. For example, use this condition to find projects where hard savings are less than $500,000.

Returns results that are less than or equal to the specified value. For example, use this condition to find projects where hard savings are less than or equal to $500,000.

Returns results that are greater than the specified value. For example, use this condition to find projects where hard savings are greater than $500,000.

Returns results that are greater than or equal to the specified value. For example, use this condition to find projects where hard savings are greater than or equal to $500,000.

Returns results that are equal to the specified value. For example, use this condition to find projects where hard savings are equal to $500,000.

Returns results that are not equal to the specified value. For example, use this condition to find projects where hard savings are not equal to $500,000.

Returns results that are before the specified date. For example, "Actual Start Date Before 1/1/21" finds projects that start before January 1, 2021.

Returns results that are on or before the specified date. For example, "Actual Start Date On Or Before 1/1/21" finds projects that start on or before January 1, 2021.

Returns results that are after the specified date. For example, "Actual Start Date After 1/1/21" finds projects that start after January 1, 2021.

Returns results that are on or after the specified date. For example, "Actual Start Date On Or After 1/1/21" finds projects that start on or after January 1, 2021.