oracle
2.96 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
GET policyproinfo/_search
{
"query": {
"bool": {
"must": [
{
"match_phrase": {
"pp_prem_source": {
"query": "1",
"slop": 0,
"boost": 1
}
}
},
{
"match_phrase": {
"pp_prem_status": {
"query": "1",
"slop": 0,
"boost": 1
}
}
},
{
"match_phrase": {
"pp_prod_seq": {
"query": "1",
"slop": 0,
"boost": 1
}
}
},
{
"range": {
"pp_prem_due_date": {
"from": "2018-11-30T16:00:00.000Z",
"to": "2019-01-01T16:00:00.000Z",
"include_lower": true,
"include_upper": true,
"boost": 1
}
}
},
{
"prefix": {
"po_branch_code": {
"value": "865100",
"boost": 1
}
}
}
],
"must_not": [
{
"match": {
"pp_product_code": {
"query": "CBAN_TN1",
"operator": "OR",
"prefix_length": 0,
"max_expansions": 50,
"fuzzy_transpositions": true,
"lenient": false,
"zero_terms_query": "NONE",
"auto_generate_synonyms_phrase_query": true,
"boost": 1
}
}
},
{
"match": {
"pp_product_code": {
"query": "CBAN_UN1",
"operator": "OR",
"prefix_length": 0,
"max_expansions": 50,
"fuzzy_transpositions": true,
"lenient": false,
"zero_terms_query": "NONE",
"auto_generate_synonyms_phrase_query": true,
"boost": 1
}
}
},
{
"match": {
"pp_product_code": {
"query": "CBAN_VN1",
"operator": "OR",
"prefix_length": 0,
"max_expansions": 50,
"fuzzy_transpositions": true,
"lenient": false,
"zero_terms_query": "NONE",
"auto_generate_synonyms_phrase_query": true,
"boost": 1
}
}
},
{
"terms": {
"rnpsi_assign_rule": [
"03"
],
"boost": 1
}
},
{
"terms": {
"po_channel_type": [
"06",
"08",
"11"
],
"boost": 1
}
}
],
"adjust_pure_negative": true,
"boost": 1
}
},
"sort": [
{
"pp_prod_seq": {
"order": "asc"
}
}
],
"aggregations": {
"distinct": {
"cardinality": {
"field": "po_policy_no"
}
}
}
}