{
    "dataSource": {
        "sources": {
            "hubs": [
                14
            ]
        },
        "relations": [
            {
                "name": "hierarchy-1003",
                "parentProject": "dbdesigner",
                "parentLevel": "1003",
                "childProject": "p274240794598",
                "childLevel": "responseid",
                "expression": {
                    "operator": "Equal",
                    "operands": [
                        {
                            "name": "id",
                            "project": "dbdesigner",
                            "level": "1003",
                            "node": "Var"
                        },
                        {
                            "name": "hierarchy",
                            "project": "p274240794598",
                            "level": "responseid",
                            "node": "Var"
                        }
                    ],
                    "node": "Binary"
                },
                "multiplicity": "one-to-many"
            }
        ],
        "prepare": [
            {
                "name": "contacts",
                "definition": [
                    {
                        "name": "ContactId",
                        "expression": {
                            "name": "ContactId",
                            "project": "p274240794598",
                            "level": "responseid",
                            "node": "Var"
                        },
                        "group": [
                            "Values"
                        ],
                        "isKey": true,
                        "item": "Select"
                    }
                ],
                "action": "NewLevel"
            },
            {
                "relation": {
                    "name": "contacts-to-responses",
                    "parentkey": {
                        "name": "ContactId",
                        "level": "contacts"
                    },
                    "childkey": {
                        "name": "ContactId",
                        "project": "p274240794598",
                        "level": "responseid"
                    },
                    "multiplicity": "one-to-many"
                },
                "action": "Link"
            },
            {
                "expression": {
                    "name": "InHierarchy",
                    "arguments": [
                        {
                            "level": "1003",
                            "project": "dbdesigner",
                            "hierarchy": "1004",
                            "node": "Hierarchy"
                        },
                        {
                            "name": "In",
                            "arguments": [
                                {
                                    "name": "id",
                                    "project": "dbdesigner",
                                    "level": "1003",
                                    "node": "Var"
                                },
                                {
                                    "type": "text",
                                    "value": "1",
                                    "node": "Constant"
                                }
                            ],
                            "node": "Call"
                        }
                    ],
                    "node": "Call"
                },
                "action": "Filter"
            },
            {
                "expression": {
                    "operator": "And",
                    "operands": [
                        {
                            "operator": "Equal",
                            "operands": [
                                {
                                    "name": "IsCurrent",
                                    "project": "p274240794598",
                                    "level": "responseid",
                                    "node": "Var"
                                },
                                {
                                    "type": "text",
                                    "value": "yes",
                                    "node": "Constant"
                                }
                            ],
                            "node": "Binary"
                        },
                        {
                            "operator": "Greater",
                            "operands": [
                                {
                                    "name": "ValidPeriod_To",
                                    "project": "p274240794598",
                                    "level": "responseid",
                                    "node": "Var"
                                },
                                {
                                    "name": "GetDate",
                                    "arguments": [],
                                    "node": "Call"
                                }
                            ],
                            "node": "Binary"
                        },
                        {
                            "operator": "NotEqual",
                            "operands": [
                                {
                                    "name": "unsubscribed",
                                    "project": "p274240794598",
                                    "level": "responseid",
                                    "node": "Var"
                                },
                                {
                                    "type": "Text",
                                    "value": "1",
                                    "node": "Constant"
                                }
                            ],
                            "node": "Binary"
                        }
                    ],
                    "node": "Binary"
                },
                "action": "Filter"
            }
        ]
    },
    "rows": [
        {
            "parentLevel": {
                "name": "responseid",
                "project": "p274240794598",
                "node": "Level"
            },
            "sortingIsFilterDependent": false,
            "skip": 0,
            "type": "List"
        }
    ],
    "settings": {
        "default": {
            "values": [
                {
                    "expression": {
                        "name": "gender",
                        "project": "p274240794598",
                        "level": "responseid",
                        "node": "Var"
                    },
                    "valueType": "Expression",
                    "id": "gender"
                },
                {
                    "expression": {
                        "name": "location",
                        "project": "p274240794598",
                        "level": "responseid",
                        "node": "Var"
                    },
                    "valueType": "Expression",
                    "id": "location"
                },
                {
                    "expression": {
                        "name": "hierarchy",
                        "project": "p274240794598",
                        "level": "responseid",
                        "node": "Var"
                    },
                    "valueType": "Expression",
                    "id": "hierarchy"
                },
                {
                    "expression": {
                        "name": "alternativeemail",
                        "project": "p274240794598",
                        "level": "responseid",
                        "node": "Var"
                    },
                    "valueType": "Expression",
                    "id": "alternativeemail"
                },
                {
                    "expression": {
                        "name": "email",
                        "project": "p274240794598",
                        "level": "responseid",
                        "node": "Var"
                    },
                    "valueType": "Expression",
                    "id": "email"
                },
                {
                    "expression": {
                        "name": "Unsubscribed",
                        "project": "p274240794598",
                        "level": "responseid",
                        "node": "Var"
                    },
                    "valueType": "Expression",
                    "id": "Unsubscribed"
                },
                {
                    "expression": {
                        "name": "ContactId",
                        "project": "p274240794598",
                        "level": "responseid",
                        "node": "Var"
                    },
                    "valueType": "Expression",
                    "id": "ContactId"
                }
            ]
        }
    }
}