To create a Case Saved Search to list cases with Date Closed in 7 or more days after Created Date, follow these steps:
1. Navigate to Lists > Search > Saved Searches > New.
2. Click Case.
3. Enter Search Title.
4. Under Criteria > Standard subtab, add the following:
- Status is Closed
- Formula (Numeric)
- Formula (paste folloving:) CASE WHEN (ROUND({closed} - {createddate}) > 7) THEN 1 ELSE 0 END
- Formula (Numeric) = equal to
- Value = 1
5. Under Results > Columns subtab, add the fields to display in the search result, for example:
- Number
- Created Date
- Date Closed
- Status
6. Click Save & Run.
No comments:
Post a Comment