Combining Implicit Joins With Data Filters

Combine implicit joins and data filter conditions to retrieve specific sets of related data stored in multiple tables.

Example Simple Query Using an Implicit Join and a Data Filter

{
    "name": "Test",
    "pageSize": "1000",
    "tables": [
                {
                 "tableName": "TASK",
                 "columns": [
                             "TASK_ID",
                             "PROJ_ID",
                             "WBS_ID",
                             "TASK_TYPE"
                            ],
                 "joinedTables": [
                                  {"tableName": "PROJECT",
                                   "columns": ["PROJ_SHORT_NAME"]
                                  }
                                 ],
                 "condition": {
                             "operator": "AND",
                             "conditions": [
                                             {"columnName": "PROJ_ID",
                                              "operator": "EQUALS",
                                              "value1": "3575"
                                             }
                                           ]
                              }
               }
            ]
}