GetJoinInfo

Get detailed join information for a project

{Explanation}

{
  "method": "GetJoinInfo"
}

{
  "info": {
    "joins": [
      {
        "primaryTable": "sample_table",
        "primaryField": "first_name",
        "foreignTable": "03_HEADER_RAW",
        "foreignField": "first_name",
        "homePath": "",
        "primaryTotal": 1277427,
        "foreignTotal": 78180465,
        "primayResolved": 14182,
        "foreignResolved": 13255434,
        "primary": [
          "sample_table.first_name"
        ],
        "foreign": [
          "03_HEADER_RAW.first_name"
        ],
        "rootFolder": "",
        "fDataSets": [
          {
            "logic": "or",
            "name": "SubSet",
            "strict": true,
            "set": [
              {
                "logic": "or",
                "stype": "TABLE",
                "entity": "03_HEADER_RAW"
              },
              {
                "logic": "or",
                "stype": "INTRINSIC",
                "intrinsic": {
                  "function": "random%",
                  "params": [
                    "17",
                    "63833412390280"
                  ]
                }
              }
            ]
          }
        ],
        "layers": 1,
        "name": "sample_table_03_HEADER_RAW",
        "injected": false
      },
      {
        "primaryTable": "sample_table_2",
        "primaryField": "first_name",
        "foreignTable": "03_HEADER_RAW",
        "foreignField": "first_name",
        "homePath": "",
        "primaryTotal": 1277427,
        "foreignTotal": 78180465,
        "primayResolved": 13744,
        "foreignResolved": 77922376,
        "primary": [
          "sample_table_2.first_name"
        ],
        "foreign": [
          "03_HEADER_RAW.first_name"
        ],
        "rootFolder": "d:\\datajet_s\\dj-localhost\\LN_Vanilla\\",
        "fDataSets": [
          {}
        ],
        "layers": 1,
        "name": "sample_table_2_03_HEADER_RAW",
        "injected": false
      },
      {
        "primaryTable": "sample_table_3",
        "primaryField": "first_name",
        "foreignTable": "sample_table_2",
        "foreignField": "first_name",
        "homePath": "",
        "primaryTotal": 3752662,
        "foreignTotal": 1277427,
        "primayResolved": 13184,
        "foreignResolved": 1276784,
        "primary": [
          "sample_table_3.first_name"
        ],
        "foreign": [
          "sample_table_2.first_name"
        ],
        "rootFolder": "d:\\datajet_s\\dj-localhost\\LN_Vanilla\\",
        "fDataSets": [
          {}
        ],
        "layers": 1,
        "name": "sample_table_3_sample_table_2",
        "injected": false
      },
      {
        "primaryTable": "sample_table_3",
        "primaryField": "first_name",
        "foreignTable": "03_HEADER_RAW",
        "foreignField": "first_name",
        "homePath": "",
        "primaryTotal": 3752662,
        "foreignTotal": 78180465,
        "primayResolved": 16927,
        "foreignResolved": 78115920,
        "primary": [
          "sample_table_3.first_name"
        ],
        "foreign": [
          "03_HEADER_RAW.first_name"
        ],
        "rootFolder": "d:\\datajet_s\\dj-localhost\\LN_Vanilla\\",
        "fDataSets": [
          {}
        ],
        "layers": 1,
        "name": "sample_table_3_03_HEADER_RAW",
        "injected": false
      }
    ]
  },
  "executed": true,
  "errors": [],
  "millis": 3,
  "projectEpoch": 638629450376249996,
  "method": "GetJoinInfo",
  "exmillis": 4
}