Monday, April 1, 2019

Create a Case Saved Search to List Cases Closed within 7 or more days after Created Date

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