Membership Activity Report - CiviCRM Data Processor Report

membership_activity_report.json

{
    "name": "membership_activity_report",
    "title": "Membership Activity Report",
    "type": "default",
    "configuration": {
        "default_sort": [
            "asc_by_activity_date"
        ]
    },
    "is_active": "1",
    "storage_configuration": [],
    "data_sources": [
        {
            "weight": "1",
            "name": "activity",
            "title": "Activity",
            "type": "activity",
            "configuration": {
                "filter": {
                    "is_test": {
                        "op": "=",
                        "value": "0"
                    },
                    "is_current_revision": {
                        "op": "=",
                        "value": "1"
                    },
                    "is_deleted": {
                        "op": "=",
                        "value": "0"
                    },
                    "activity_contact_record_type_id": {
                        "op": "IN",
                        "value": [
                            "3"
                        ]
                    }
                },
                "aggregate_function": "",
                "aggregate_by": []
            },
            "join_configuration": []
        },
        {
            "weight": "2",
            "name": "membership",
            "title": "Membership",
            "type": "membership",
            "configuration": {
                "filter": {
                    "is_test": {
                        "op": "=",
                        "value": "0"
                    }
                },
                "aggregate_function": "",
                "aggregate_by": []
            },
            "join_type": "simple_join",
            "join_configuration": {
                "left_prefix": "membership",
                "left_field": "membership_id",
                "right_prefix": "activity",
                "right_field": "activity_source_record_id"
            }
        },
        {
            "weight": "3",
            "name": "contact",
            "title": "Contact",
            "type": "contact",
            "configuration": {
                "filter": {
                    "is_deleted": {
                        "op": "=",
                        "value": "0"
                    }
                }
            },
            "join_type": "simple_join",
            "join_configuration": {
                "left_prefix": "contact",
                "left_field": "contact_id",
                "right_prefix": "membership",
                "right_field": "membership_contact_id"
            }
        }
    ],
    "filters": [
        {
            "weight": "1",
            "name": "activity_date",
            "title": "Activity Date",
            "type": "simple_sql_filter",
            "is_required": "0",
            "is_exposed": "1",
            "configuration": {
                "field": "activity_activity_date_time",
                "datasource": "activity"
            },
            "filter_value": []
        },
        {
            "weight": "3",
            "name": "activity_type",
            "title": "Activity Type",
            "type": "simple_sql_filter",
            "is_required": "0",
            "is_exposed": "1",
            "configuration": {
                "field": "activity_activity_type_id",
                "datasource": "activity"
            },
            "filter_value": {
                "op": "IN",
                "value": [
                    "7",
                    "8"
                ]
            }
        },
        {
            "weight": "4",
            "name": "activity_type_id",
            "title": "Activity Type ID",
            "type": "simple_sql_filter",
            "is_required": "0",
            "is_exposed": "0",
            "configuration": {
                "field": "activity_activity_type_id",
                "datasource": "activity"
            },
            "filter_value": {
                "op": "IN",
                "value": [
                    "7",
                    "8"
                ]
            }
        },
        {
            "weight": "5",
            "name": "activity_status",
            "title": "Activity Status",
            "type": "simple_sql_filter",
            "is_required": "0",
            "is_exposed": "0",
            "configuration": {
                "field": "activity_status_id",
                "datasource": "activity"
            },
            "filter_value": {
                "op": "IN",
                "value": [
                    "2"
                ]
            }
        },
        {
            "weight": "6",
            "name": "membership_type_id",
            "title": "Membership Type",
            "type": "simple_sql_filter",
            "is_required": "0",
            "is_exposed": "1",
            "configuration": {
                "field": "membership_membership_type_id",
                "datasource": "membership"
            },
            "filter_value": []
        }
    ],
    "fields": [
        {
            "weight": "2",
            "name": "activity_date",
            "title": "Activity Date",
            "type": "date",
            "configuration": {
                "field": "activity_activity_date_time",
                "datasource": "activity",
                "is_aggregate": "",
                "function": "",
                "format": "d\/m\/Y"
            }
        },
        {
            "weight": "4",
            "name": "contact_id",
            "title": "Contact",
            "type": "contact_link",
            "configuration": {
                "contact_id_field": "contact_id",
                "contact_id_datasource": "contact",
                "contact_name_field": "contact_display_name",
                "contact_name_datasource": "contact"
            }
        },
        {
            "weight": "5",
            "name": "activity_type_id",
            "title": "Activity Type",
            "type": "option_label",
            "configuration": {
                "field": "activity_activity_type_id",
                "datasource": "activity",
                "is_aggregate": ""
            }
        },
        {
            "weight": "6",
            "name": "membership_type_id",
            "title": "Membership Type",
            "type": "option_label",
            "configuration": {
                "field": "membership_membership_type_id",
                "datasource": "membership",
                "is_aggregate": ""
            }
        }
    ],
    "outputs": [
        {
            "type": "search",
            "configuration": {
                "id_field": "contact_id",
                "navigation_parent_path": "Memberships",
                "navigation_weight": "99",
                "no_result_text": "",
                "hide_id_field": "0",
                "hidden_fields": [],
                "help_text": "",
                "expanded_search": "",
                "expose_aggregate": "",
                "expose_hidden_fields": ""
            },
            "permission": "access CiviCRM"
        },
        {
            "type": "export_csv",
            "configuration": {
                "anonymous": "",
                "delimiter": ",",
                "enclosure": "\"",
                "escape_char": "\\"
            }
        }
    ]
}