Answers.Body: <p>Craig - it's worse than that: creating two reports with 'Yes' &amp; 'No' will still not give you all the cases if they don't have relationships.</p>
  
  <p>See <a href="https://lab.civicrm.org/dev/report/issues/24" rel="nofollow noreferrer">https://lab.civicrm.org/dev/report/issues/24</a> and the related PR. </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-18T08:41:42.910Z
Answers.Text: Thanks to Aidan's PR this is fixed in 5.22
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-11-27T16:40:04.980Z
Answers.LastActivityDate: 2019-11-27T16:40:04.980Z
Answers.UserDisplayName: Aidan
Answers.Body: <p>It looks like it was added <a href="https://github.com/civicrm/civicrm-core/pull/12711" rel="nofollow noreferrer">here</a>. The gist of it seems to be to address an issue when wanting to see only current staff. You might want to file an issue at lab.civicrm.org requesting a "neither" option. I don't know of a quick fix other than to see if reverting those changes listed <a href="https://github.com/civicrm/civicrm-core/commit/742749c58a2587e9f11ef6291e760c5c27e810b9" rel="nofollow noreferrer">here</a> solve it.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-10T15:27:16.663Z
Answers.Text: Thank you. I was about to come in and delete the question. (Posted in a bout of frustration), but your answer gives me something specific to post in the lab.
Answers.UserDisplayName: Craig Almond
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-10T15:22:44.820Z
Answers.LastActivityDate: 2019-03-10T15:22:44.820Z
Answers.UserDisplayName: Demerit
Body: <p>Trying to run a case details report for all cases of type "x" opened between a given date range.</p>
  
  <p>Noticed that not as many cases as expected show.</p>
  
  <p>On further investigation found that there is a filter in the template
  Active role:is equal to- options yes or no
  Which effectively switches between open and closed cases</p>
  
  <p>Anyone know the reason for this?</p>
  
  <p>there is no option for neither, and the filter can't be removed, so I'm now left creating two reports for every case type on the system. Or creating a drupal view per case type</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-03-10T18:58:17.103Z
Comments.Text: You want an option for neither? or for both? or for Clear?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-03-10T22:00:09.887Z
Comments.Text: An option not to have it as an option. If that makes sense. I'll try and put something coherent in the issue queue later.
Comments.UserDisplayName: Craig Almond
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-03-12T10:21:04.450Z
Comments.Text: Craig - fyi, just hit the same problem.  I get no results where it is set to Yes or No, but previously it did. Will be investigating further ...
Comments.UserDisplayName: Aidan
Tags: <civireport><civicase>
Title: Case Details Report- Active Case Role filter
ThreadText: # Case Details Report- Active Case Role filter
  
  (Asked by: username_0 on 2019-03-10)
  
  Trying to run a case details report for all cases of type "x" opened between a given date range.
  
  Noticed that not as many cases as expected show.
  
  On further investigation found that there is a filter in the template
  Active role:is equal to- options yes or no
  Which effectively switches between open and closed cases
  
  Anyone know the reason for this?
  
  there is no option for neither, and the filter can't be removed, so I'm now left creating two reports for every case type on the system. Or creating a drupal view per case type
  
  **Tags:** civireport, civicase
  
  > **Comments:**
  > **username_1**: You want an option for neither? or for both? or for Clear?  
  > **username_0**: An option not to have it as an option. If that makes sense. I'll try and put something coherent in the issue queue later.  
  > **username_2**: username_0 - fyi, just hit the same problem.  I get no results where it is set to Yes or No, but previously it did. Will be investigating further ...  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2019-11-27. Score: 2 | Accepted answer
  
  username_0 - it's worse than that: creating two reports with 'Yes' & 'No' will still not give you all the cases if they don't have relationships.
  
  See <https://lab.civicrm.org/dev/report/issues/24> and the related PR.
  
  > **Comments:**
  > **username_3**: Thanks to username_2's PR this is fixed in 5.22  
  
  ---
  
  ### Answer by username_3 on 2019-03-10. Score: 1
  
  It looks like it was added [here](https://github.com/civicrm/civicrm-core/pull/12711). The gist of it seems to be to address an issue when wanting to see only current staff. You might want to file an issue at lab.civicrm.org requesting a "neither" option. I don't know of a quick fix other than to see if reverting those changes listed [here](https://github.com/civicrm/civicrm-core/commit/742749c58a2587e9f11ef6291e760c5c27e810b9) solve it.
  
  > **Comments:**
  > **username_0**: Thank you. I was about to come in and delete the question. (Posted in a bout of frustration), but your answer gives me something specific to post in the lab.  
  
  ---
  
  