Filter Operators

Default filter and Custom filter operator and its descriptions

Default Filter options

Default Operators

NO	KEY	TYPE	DESC	SYMBOLIC SQL
1	lt	string	less than	<
2	lte	string	less than or equal to	≤
3	gt	string	greater than	>
4	gte	string	greater than or equal to	≥
5	eq	string	equal to	=
6	not	string		!=
7	exists	string	exists	EXISTS
8	contain	string	contains	%str%
9	not_contain	string	not contains	NOT LIKE '%str%';
10	in	string	include	IN ("a","b","c")
11	not_in	string	not include	NOT IN ("a", "b", "c")
12	not_contain_in	string	no contain in	NOT IN ('%A%', '%B%', '%C%')
13	match	string		WHERE T.A='a' AND T.B='b'

FILTER REGULATIONS:

• Match

  • Search field with k (key) MUST be list of dict

  • Only offers dict type in value

  • Case-sensitive in value

  • Full-match only

    • refers to $elemMatch (query)

Sample Input

{
    "domain_id": "{domain_id}",
    "query": {
        "filter": [
            {
                "k": "data.disk.core",
                "v": 4,
                "o": "gte"
            },
            {
                "k": "tags.spaceone:plugin_name",
                "v": "aws-health",
                "o": "eq"
            },
            {
                "k": "data.softwares", 
                "v": { "version": "1.0.0", "name": "mysql" }, 
                "o": "match"
             }
        ]
    }
}

Custom Filter Options