Create a Data Service Query with a Compound Join Condition
Run queries having join and filter conditions.
Example Compound 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" } } ] } ] }