Using Implicit Joins

Run queries using joins to retrieve data from two related tables.

Example Query With an Implicit Join to a Single Inner Table

{
  "name": "Project Activites",
  "pageSize": "1000",
  "tables": [
              {
                "tableName": "TASK",
                "columns": [
                             "TASK_ID",
                             "PROJ_ID",
                             "WBS_ID",
                             "TASK_TYPE"
                            ],
                "joinedTables": [
                     {
                       "tableName": "PROJECT",
                       "columns": ["PROJ_SHORT_NAME"]
                     }
                 ]
               }
            ]
}

Example Query With Implicit Joins of Multiple Inner Tables

{
    "name": "Test",
    "pageSize": "1000",
    "tables": [
                {
                 "tableName": "TASK",
                 "columns": [
                             "TASK_ID",
                             "PROJ_ID",
                             "WBS_ID",
                             "TASK_TYPE"
                            ],
                 "joinedTables": [
                                  {"tableName": "PROJECT",
                                   "columns": ["PROJ_SHORT_NAME"]
                                  },
                                  {"tableName": "PROJWBS",
                                   "columns": ["WBS_NAME"]
                                  },
                                  {"tableName": "CALENDAR",
                                   "columns": ["CLNDR_NAME"]
                                  }
                                 ] 
               }
            ]
}  

The incorrect use of implicit joins will fail to fetch data. In the example below there is no implicit join specified between the TASK and TASKRSRC tables.

Example of a Failed Implicit Join

{
    "name": "Test",
    "pageSize": "1000",
    "tables": [
                {
                 "tableName": "TASK",
                 "columns": [
                             "TASK_ID",
                             "PROJ_ID",
                             "WBS_ID",
                             "TASK_TYPE"
                            ],
                 "joinedTables": [
                                  {"tableName": "TASKRSRC",
                                   "columns": ["TASKRSRC_ID"]
                                  }
                                 ] 
               }
            ]
}