Using Between
Use the between operator condition to narrow the data selected to that between the given values.
Example Simple Query Using Between
{ "name": "My Activities", "tables": [ { "tableName": "TASK", "columns": [ "PROJ_ID", "TASK_ID", "TASK_NAME", "TASK_TYPE", "STATUS_CODE", "ACT_START_DATE", "ACT_END_DATE" ], "condition": { "operator": "AND", "conditions": [ { "columnName": "PROJ_ID", "operator": "BETWEEN", "value1": "4603", "value2": "4800" } ] } } ] }