用 Script 檢查 Elastic 的 Field

$myScript = 'if(doc["minAge"].value > 0 && doc["maxAge"].value == 0) {doc["minAge"].value <= ' . $member['age'] .
    '} else if (doc["minAge"].value == 0 && doc["maxAge"].value > 0) {doc["maxAge"].value <= ' . $member['age'] .
    '} else {doc["minAge"].value <= ' . $member['age'] . ' && doc["maxAge"].value >= ' . $member['age'] . '}';


$query['must'][] = [
    [
        'exists' => [
            'field' => 'minAge'
        ]
    ],
    [
        'exists' => [
            'field' => 'maxAge'
        ]
    ]
];

$query['must'][] = [
    'script' => [
        'script' => [
            'source' => $myScript
        ]
    ]
];
xxxxxxxxxx
 
1
$myScript = 'if(doc["minAge"].value > 0 && doc["maxAge"].value == 0) {doc["minAge"].value <= ' . $member['age'] .
2
    '} else if (doc["minAge"].value == 0 && doc["maxAge"].value > 0) {doc["maxAge"].value <= ' . $member['age'] .
3
    '} else {doc["minAge"].value <= ' . $member['age'] . ' && doc["maxAge"].value >= ' . $member['age'] . '}';
4
​
5
​
6
$query['must'][] = [
7
    [
8
        'exists' => [
9
            'field' => 'minAge'
10
        ]
11
    ],
12
    [
13
        'exists' => [
14
            'field' => 'maxAge'
15
        ]
16
    ]
17
];
18
​
19
$query['must'][] = [
20
    'script' => [
21
        'script' => [
22
            'source' => $myScript
23
        ]
24
    ]
25
];

GET /member/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "exists": {
            "field": "minAge"
          }
        },
        {
          "exists": {
            "field": "maxAge"
          }
        },
        {
          "script": {
            "script": {
              "source": "(doc['minAge'].value > 0 && doc['minAge'].value < 150) || (doc['minAge'].value > 0 && doc['maxAge'].value >= 100)"
              
            }
          }
        }
      ]
    }
  }, 
  "size": 20
}
xxxxxxxxxx
 
1
GET /member/_search
2
{
3
  "query": {
4
    "bool": {
5
      "must": [
6
        {
7
          "exists": {
8
            "field": "minAge"
9
          }
10
        },
11
        {
12
          "exists": {
13
            "field": "maxAge"
14
          }
15
        },
16
        {
17
          "script": {
18
            "script": {
19
              "source": "(doc['minAge'].value > 0 && doc['minAge'].value < 150) || (doc['minAge'].value > 0 && doc['maxAge'].value >= 100)"
20
              
21
            }
22
          }
23
        }
24
      ]
25
    }
26
  }, 
27
  "size": 20
28
}