Dynamic Report block does not work with Workflow Attributes on Filters

[jamrphy-bwd]

Description

The Dynamic Report block does not work with Workflow Attributes.

Steps to Reproduce

1. Create a Data View (applies to Workflow) with filters for any workflow attribute
2. Create a Report on the Data View. Column Selection is arbitrary.
3. Add the Dynamic Report block to a page. In the configuration, select the report from step 2.
4. Make all selected Attribute and Property Filters Visible and Configurable in the Block Configuration.
5. See below for error behavior.

Expected behavior:

The page should load to show all filters marked "Visible" in the settings. Attribute-based filters should show selection mechanisms (i.e. a drop down list) based on the data type of the attribute. Clicking the "Reset Filters" link should clear the adjusted selections, but leave the form unchanged. Submitting the form via the "Filter" button should apply the selected filters from both properties and attributes to the underlying DataView and return the correct results through the Report.

Actual behavior:

On load, the page shows the "Toggle" checkboxes for all attribute filters. However, the "Configuration" selection mechanisms are not shown. Clicking the "Reset Filters" link seems to correctly load the form (the Attribute Filter selects then show). Submitting the form via the "Filter" button applies Property-based filters to the results, but no attribute filters. The block reloads having cleared selections on attribute filters. The label for the attribute filters "Toggle" displays nonsense (perhaps an ID) such as "51fe9641-fb8f-41bf-b09e-235900c3e53e".

Versions

• Rock Version: Rock McKinley 7.5 (1.7.5.59) and Demo Site (8.4)
• Client Culture Setting: en-US

┆Attachments: image.png

[BEGamache]

I was able to replicate this and got some slightly different results.
Property filters do display in the filter section correctly. Attribute filters only show the checkbox and the attribute's GUID, no filter controls. Clicking Reset Filters does reload and display the missing attribute filters but since it is using the Attribute's GUID you don't know what attribute you are filtering on.

The results are not correct. In the Data View I created for testing, I only have one result that correctly displays. In the Dynamic Report there are 19 rows--all but one don't match the filters I placed in the Data View. In further testing, when Visible, Configurable and Toggle Filter are not checked for the attributes in the block's settings, the results are correct.

This is also where I got different results. I tested this in v10 Alpha and when Visible, Configurable and Toggle Filter are check in the Dynamic Report's block setting it cleared the Data View filters I had on workflow attributes. I can setup the data view again with the proper filters but once I reload/access the page with the Dynamic Report it clears the filters in the Data View -- not the workflow fields, only the workflow attribute values filters. As a result of it altering the data view's filters I don't have proper filter controls in the Dynamic Report block.

In v9 it didn't alter the Data View but in v10 it alters the Data View by clearing out attribute filters.

Data View before:

Report Before:

Dynamic Report Block:

Data View After Running the Dynamic Report:

Labeling as High because in v10 this block can alter the data view itself.

[SteveSwaringen]

Seeing the same issue trying to reference a date attribute on a workflow. Running 10.2 and seeing the data view corrupted.