SDP API v3 中条件如何添加 “与” “或” “非” 逻辑运算

SDP API v3 中条件如何添加 “与” “或” “非” 逻辑运算


例1、通过 search_fields 字段
获取状态为 open,优先级为 high 的请求参数格式如下
input_data= 
{
    "list_info":{
        "search_fields":{
            "status.name":"open",
            "priority.name":"high"
        }

    }

}
例2、通过 search_criteria 字段
获取状态为 onhold,支持组为 Network 的请求参数格式如下
input_data=
{
    "list_info":{
        "search_criteria":[
            {
                "field":"group.name",
                "condition":"is",
                "values":[
                    "Network"
                ]

            }
,
            {
                "field":"status.name",
                "condition":"is",
                "logical_operator":"and",
                "values":[
                    "onhold"
                ]

            }

        ]

    }

}


例3、获取状态为 open 或 closed 的请求参数格式如下
input_data=
{
    "list_info":{
        "search_criteria":[
            {
                "field":"status.name",
                "condition":"is",
                "logical_operator":"or",
                "values":[
                    "open",
                    "closed"
                ]

            }

        ]

    }

}

例4、获取工作组为 Network 或 状态为 open 的请求参数格式如下
input_data=
{
    "list_info":{
        "search_criteria":[
            {
                "field":"group.name",
                "condition":"is",
                "values":[
                    "Network"
                ]

            }
,
            {
                "field":"status.name",
                "condition":"is",
                "logical_operator":"or",
                "values":[
                    "open"
                ]

            }

        ]

    }

}

例5、获取状态不为 Closed 的请求参数格式如下
input_data=
{
    "list_info":{
        "search_criteria":[
            {
                "field":"status.name",
                "condition":"is not",
                "values":[
                    "Closed"
                ]

            }

        ]

    }

}

其它条件

不同的字段适用的条件不同,请参照请求列表页面中的过滤器配置

小于

"condition":"lesser than"

大于

"condition": "greater than"

为空

"condition":"is","value":null

不为空

"condition":"is not","value":null

包含

"condition":"contains"

不包含

"condition":"not contains"

开始字符

"condition":"starts with"

结束字符

"condition":"ends with"


SDP云版的API维护得好一点,大部分可通用,供参考
https://www.manageengine.com/products/service-desk/sdpod-v3-api/getting-started/input-data.html
云版本逻辑运算示例,供参考
https://www.manageengine.com/products/service-desk/sdpod-v3-api/getting-started/search-criteria.html