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" } ] } } ] }