Tuesday, April 9, 2019

Create a Saved Search for Closed Cases That Have Not Been Re-Opened

1. Navigate to Lists > Search > Saved Search > New.
2. Choose Case.
3. Provide a Search Title.
4. In the Criteria tab, input the field below:
     > Formula (Text) or Formula (Numeric)
          -Formula: CASE WHEN {status} = 'Closed' AND {lastreopeneddate} is NULL THEN 1 ELSE 0 END
          -Formula (Numeric): equal to (is)
          -Value: 1
5. In the Results tab, enter fields as necessary.
6. Save & Run.

No comments:

Post a Comment