Unable to pull Inactive groups in a dataview

[karenn-ccbc]

Prerequisites

• [X ] Put an X between the brackets on this line if you have done all of the following:
  • Did you perform a search at https://github.com/issues?q=is%3Aissue+user%3ASparkDevNetwork+-repo%3ARock to see if your bug or enhancement is already reported?
  • Can you reproduce the problem on a fresh install or the demo site?
  • Did you include your Rock version number and client culture setting?

A Picture Is worth a Thousand Words

Description

I am trying to create a Dynamic Report that will allow a person to pull child groups that are active OR inactive when they select a parent group. The IsActive Filter in the Dynamic Report is not working when it is set to Is Active = Yes in the dataview, so I attempted to just create a dataview to pull those inactive groups alone and am unable to do so.

Steps to Reproduce

1. Go to 'Group Viewer'
2. Inactivate a Parent and child groups
3. Create a Dataview on Groups and select the Inactive Parent group for Group Branch
4. Filter and No results
5. Add in a filter for IsActive=No and still no results

Expected behavior:

I would expect the dataview to show the child groups that are inactive

Actual behavior:

No results

Versions

• Rock Version: 13.6
• Client Culture Setting: [Enter Client Culture here]