· 5 years ago · Mar 09, 2020, 04:32 PM
1GET usersindex/_mapping
2
3
4GET usersindex/_search
5{
6 "query": {
7 "regexp": {
8 "name": {
9 "value": "@.ska.@"
10 }
11 }
12 },
13 "size": 10000
14}
15
16GET usersindex/_search
17{
18 "query": {
19 "query_string": {
20 "default_field": "email",
21 "query": "*gmail.com"
22 }
23 },
24 "size": 10000
25}
26
27GET usersindex/_search
28{
29 "query": {
30 "query_string": {
31 "default_field": "email"
32 "query": "*gmail*"
33 }
34 }
35}
36
37GET usersindex/_search
38{
39 "query": {
40 "match_all": {
41
42 }
43 }
44}
45
46GET usersindex/_search
47{
48 "query": {
49 "bool": {
50 "must": [
51 {
52 "bool": {
53 "should": [
54 {
55 "regexp": {
56 "name": {
57 "value": "@.ska.@"
58 }
59 }
60 },
61 {
62 "regexp": {
63 "lastname": {
64 "value": "@.ska.@"
65 }
66 }
67 }
68 ],
69 "minimum_should_match": 1
70 }
71 },
72 {
73 "term": {
74 "gender.keyword": {
75 "value": "male"
76 }
77 }
78 }
79 ]
80 }
81 }
82}
83
84GET usersindex/_mapping
85
86GET usersindex/_search
87{
88 "query": {
89 "bool": {
90 "filter": {
91 "script": {
92 "script": {
93 "source": "doc['name.keyword'].length != 0 && doc['name.keyword'].length <= 30",
94 "lang": "painless"
95 }
96 }
97 }
98 }
99 }
100}
101
102GET usersindex/_mapping
103
104GET usersindex/_search
105{
106 "query": {
107 "bool": {
108 "filter": {
109 "script": {
110 "script": {
111 "source": "(Date)doc['userDefined.created'] >= new Date(1420074061) && (Date)doc['userDefined.created'] <= new Date(1583715661)",
112 "lang": "painless"
113 }
114 }
115 }
116 }
117 }
118}
119
120GET usersindex/_search
121{
122 "query": {
123 "bool": {
124 "should": [
125 {
126 "nested": {
127 "path": "userDefined",
128 "query": {
129 "range": {
130 "userDefined.created": {
131 "gte": 1420074061,
132 "lte": 1583715661
133 }
134 }
135 }
136 }
137 },
138 {
139 "query_string": {
140 "query": "698* OR 697* AND *gmail.com",
141 "fields": ["mobile","email"]
142
143 }
144 },
145 {
146 "nested": {
147 "path": "userDefined",
148 "query": {
149 "range": {
150 "userDefined.field_dateofbirth": {
151
152 "gte": "1940-01-01T22:00:00Z"
153 }
154 }
155 }
156 }
157 },
158 {
159 "nested": {
160 "path": "userDefined",
161 "query": {
162 "query_string": {
163 "default_field": "userDefined.init",
164 "query": "email*"
165 }
166 }
167 }
168 }
169
170 ]
171 }
172 }
173}