Combining AND, OR, and BETWEEN
Use the between operator condition to narrow the data selected to that between the given values.
Example of combining AND, OR, and BETWEEN
{ "name": "Get SYS_STG_BP details", "tables": [ { "tableName": "SYS_STG_BP", "columns": [ "BP_OBJECT_ID", "PROJECT_OBJECT_ID", "UNIFIER_RECORD_ID", "BP_NAME", "BP_TYPE" ], "condition": { "operator": "AND", "conditions": [ { "operator": "OR", "conditions": [ { "operator": "EQUALS", "columnName": "BP_OBJECT_ID", "value1": "1000060000000002" }, { "operator": "EQUALS", "columnName": "BP_OBJECT_ID", "value1": "1000060000000018" } ] }, { "operator": "AND", "conditions": [ { "operator": "BETWEEN", "columnName": "UNIFIER_RECORD_ID", "value1": "2", "value2": "18" } ] } ] } } ] }