Create a Data Service Query with an Explicit Join and Conditions Within Joins

Run queries with explicit joins and conditions within joins.

Example Explicit Join and Condition Within Join

{
  "name" : "TestQuery",
  "sinceDate" : "2001-01-01 17:30:00",
  "pageSize" : "500",
  "nextTableName" : null,
  "nextKey" : null,
  "tables" : [ {
    "tableName" : "TASK",
    "columns" : [ "TASK_ID", "TASK_NAME", "TASK_TYPE", "STATUS_CODE", "EARLY_START_DATE", "EARLY_END_DATE" ],
    "condition" : {
      "operator" : "AND",
      "conditions" : [ {
        "columnName" : "TARGET_WORK_QTY",
        "operator" : "GREATER_THAN_OR_EQUALS",
        "value1" : "40",
        "value2" : null
      } ]
    },
    "joinedTables" : [ {
      "tableName" : "PROJECT",
      "columns" : ["PROJ_ID", "PROJ_SHORT_NAME"],
      "condition" : {
      "operator" : "AND",
      "conditions": [{
        "columnName" : "PROJ_ID",
        "operator" : "EQUALS",
        "value1" : "3885",
        "value2" : null
      }]
      },
      "joinCondition" :{
        "columnName1" : "TASK.PROJ_ID",
        "columnName2": "PROJECT.PROJ_ID"
        }
    },{
      "tableName" : "TASKRSRC",
      "columns" : ["TASK_ID", "RSRC_ID"],
      "joinCondition" :{
        "columnName1" : "TASK.TASK_ID",
        "columnName2": "TASKRSRC.TASK_ID"
    }
    } ]
     
  } ]
}