Using LIKE and IN

LIKE

Use this operator to filter data with values for a column that contains a specific text string. The string might appear at the start, end, or at any point in the column value. This operator is case sensitive, therefore, the strings "E-201 Install", "e-201 install", and "E-201 INSTALL" are distinct and separate strings.

The example query below would return all rows where the column TASK_NAME included the string "E-201 Install" at any point.

Example Query Using LIKE

{
    "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": "TASK_NAME",
                        "operator": "LIKE",
                        "value1": "E-201 Install"
                    }
                ]
            }
        }
    ]
}

IN

Use this operator to filter data with values matching any one of the comma-separated values you specify. The column must contain the exact value specified and nothing else to be returned. If used to match text strings, this operator is case sensitive. You can specify a maximum of 1,000 values for the query.

The example query below would return all rows where the column PROJ_ID contains any of the values "4603", "4049", "4807", or "4417".

Example Query Using IN

{
    "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": "IN",
                        "value1": "4603,4049,4807,4417"
                    }
                ]
            }
        }
    ]   
}