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