Skip to content

Instantly share code, notes, and snippets.

@chesster

chesster/new.json

Created January 25, 2018 16:25
Show Gist options
  • Save chesster/be5a40f1c1411705be230593e20730fa to your computer and use it in GitHub Desktop.
Save chesster/be5a40f1c1411705be230593e20730fa to your computer and use it in GitHub Desktop.
Download ZIP
sweet16
Raw
new.json
{
"59fb3ab7cd535a0011ea6667": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "work"
}
},
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.countryCode": "HUN"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "DNK"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "FIN"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "NOR"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "SWE"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GIB"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MLT"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ZZZZZZZZZZZ2"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "IRL"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "IOM"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "LIE"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MCO"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHE"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.potentialWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.potentialWealth.convertedValues.minValue"
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.estimatedWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.estimatedWealth.convertedValues.minValue"
}
}
}
}
]
}
},
{
"bool": {
"should": [
[
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 8,
"gte": 4
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 16,
"gte": 8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 24,
"gte": 16
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 40,
"gte": 32
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"gte": 40
}
}
}
]
}
}
}
}
]
]
}
},
{
"bool": {
"should": [
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-19y",
"gte": "now-34y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-34y",
"gte": "now-49y"
}
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.telephones",
"query": {
"bool": {
"should": [
{
"term": {
"personalDetails.telephones.numberType": "mobile"
}
},
{
"term": {
"personalDetails.telephones.numberType": "phone"
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.emailAddresses",
"query": {
"bool": {
"must": [
{
"exists": {
"field": "personalDetails.emailAddresses"
}
}
]
}
}
}
}
]
}
}
],
"59f893c7b87fcc0011c5a1c9": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "work"
}
},
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"GBR_GREATER_LONDON"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
}
]
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.potentialWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.potentialWealth.convertedValues.minValue"
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.estimatedWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.estimatedWealth.convertedValues.minValue"
}
}
}
}
]
}
},
{
"bool": {
"should": [
[
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 0.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 2.8,
"gte": 0.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 4,
"gte": 2.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 8,
"gte": 4
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 16,
"gte": 8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 24,
"gte": 16
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 32,
"gte": 24
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 40,
"gte": 32
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"gte": 40
}
}
}
]
}
}
}
}
]
]
}
},
{
"bool": {
"should": [
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-34y",
"gte": "now-49y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-49y",
"gte": "now-59y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-59y"
}
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"gender": "male"
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.telephones",
"query": {
"bool": {
"should": [
{
"term": {
"personalDetails.telephones.numberType": "mobile"
}
},
{
"term": {
"personalDetails.telephones.numberType": "phone"
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.emailAddresses",
"query": {
"bool": {
"must": [
{
"exists": {
"field": "personalDetails.emailAddresses"
}
}
]
}
}
}
}
]
}
}
],
"59d7a18575862700120d0742": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "work"
}
},
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.countryCode": "ARM"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "AZE"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BIH"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BGR"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CRO"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CZE"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "EST"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "HUN"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "LVA"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "LTU"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MKD"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MDA"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MNE"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "POL"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ROM"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "SRB"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "SER"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "SVK"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "SVN"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "UKR"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "DNK"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "FRO"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "FIN"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GRL"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ISL"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "NOR"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "SWE"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ALB"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CYP"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GIB"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GRC"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MLT"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "PRT"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "SMR"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ESP"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "TUR"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "AND"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "AUT"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BEL"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ZZZZZZZZZZZ2"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "FRA"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "DEU"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "IRL"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "IOM"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "LIE"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "LUX"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MCO"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "NLD"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHE"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
[
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 24,
"gte": 16
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 32,
"gte": 24
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"gte": 40
}
}
}
]
}
}
}
}
]
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.telephones",
"query": {
"bool": {
"should": [
{
"term": {
"personalDetails.telephones.numberType": "mobile"
}
},
{
"term": {
"personalDetails.telephones.numberType": "phone"
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.emailAddresses",
"query": {
"bool": {
"must": [
{
"exists": {
"field": "personalDetails.emailAddresses"
}
}
]
}
}
}
}
]
}
}
],
"5a66252664c0060012b0d5a8": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRK"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CAM"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DEV"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DOR"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"GBR_GREATER_LONDON"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"HAM"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"HRT"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KEN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"OXF"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SOM"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SFK"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SRY"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"WAR"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SXW"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
}
]
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.potentialWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.potentialWealth.convertedValues.minValue"
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.estimatedWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.estimatedWealth.convertedValues.minValue"
}
}
}
}
]
}
},
{
"bool": {
"should": [
[
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 0.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 2.8,
"gte": 0.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 4,
"gte": 2.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 8,
"gte": 4
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 16,
"gte": 8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 24,
"gte": 16
}
}
}
]
}
}
}
}
]
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.telephones",
"query": {
"bool": {
"should": [
{
"term": {
"personalDetails.telephones.numberType": "mobile"
}
},
{
"term": {
"personalDetails.telephones.numberType": "phone"
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.emailAddresses",
"query": {
"bool": {
"must": [
{
"exists": {
"field": "personalDetails.emailAddresses"
}
}
]
}
}
}
}
]
}
}
],
"5a05af62e3463c001251f04e": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "work"
}
},
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.countryCode": "DEU"
}
}
]
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.estimatedWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.estimatedWealth.convertedValues.minValue"
}
}
}
}
]
}
},
{
"bool": {
"should": [
[
{
"bool": {
"must_not": {
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"exists": {
"field": "wealthSummary.totalWealth.convertedValues"
}
}
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 0.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 2.8,
"gte": 0.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 4,
"gte": 2.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 8,
"gte": 4
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 16,
"gte": 8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 24,
"gte": 16
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 32,
"gte": 24
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 40,
"gte": 32
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"gte": 40
}
}
}
]
}
}
}
}
]
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.telephones",
"query": {
"bool": {
"should": [
{
"term": {
"personalDetails.telephones.numberType": "mobile"
}
},
{
"term": {
"personalDetails.telephones.numberType": "phone"
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.emailAddresses",
"query": {
"bool": {
"must": [
{
"exists": {
"field": "personalDetails.emailAddresses"
}
}
]
}
}
}
}
]
}
}
],
"59d7a26d223b55001230e858": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "work"
}
},
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"AL"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"AR"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CO"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"FL"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"LA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NM"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"OK"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"TX"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
}
]
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.potentialWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.potentialWealth.convertedValues.minValue"
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.estimatedWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.estimatedWealth.convertedValues.minValue"
}
}
}
}
]
}
},
{
"bool": {
"should": [
[
{
"bool": {
"must_not": {
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"exists": {
"field": "wealthSummary.totalWealth.convertedValues"
}
}
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 0.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 2.8,
"gte": 0.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 4,
"gte": 2.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 8,
"gte": 4
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 16,
"gte": 8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 24,
"gte": 16
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 32,
"gte": 24
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 40,
"gte": 32
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"gte": 40
}
}
}
]
}
}
}
}
]
]
}
},
{
"bool": {
"should": [
{
"range": {
"personalDetails.generalDetails.birthDate": {
"gte": "now-19y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-19y",
"gte": "now-34y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-34y",
"gte": "now-49y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-49y",
"gte": "now-59y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-59y"
}
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"gender": "male"
}
},
{
"term": {
"gender": "female"
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"terms": {
"gender": [
"male",
"female"
]
}
}
]
}
},
{
"bool": {
"must_not": {
"exists": {
"field": "gender"
}
}
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.telephones",
"query": {
"bool": {
"should": [
{
"term": {
"personalDetails.telephones.numberType": "mobile"
}
},
{
"term": {
"personalDetails.telephones.numberType": "phone"
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.emailAddresses",
"query": {
"bool": {
"must": [
{
"exists": {
"field": "personalDetails.emailAddresses"
}
}
]
}
}
}
}
]
}
}
],
"59d7a10ef9741a00121f50be": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "work"
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DE-BE"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "DEU"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DE-BR"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "DEU"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DE-MV"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "DEU"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DE-NI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "DEU"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DE-SN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "DEU"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DE-TH"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "DEU"
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"match_phrase": {
"personalDetails.addresses.zip": "10719"
}
}
]
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
[
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 8,
"gte": 4
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 16,
"gte": 8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 24,
"gte": 16
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 32,
"gte": 24
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 40,
"gte": 32
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"gte": 40
}
}
}
]
}
}
}
}
]
]
}
}
],
"59d79fbff9741a00121f4f6c": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "work"
}
},
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.potentialWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.potentialWealth.convertedValues.minValue"
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.estimatedWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.estimatedWealth.convertedValues.minValue"
}
}
}
}
]
}
},
{
"bool": {
"should": [
[
{
"bool": {
"must_not": {
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"exists": {
"field": "wealthSummary.totalWealth.convertedValues"
}
}
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 8,
"gte": 4
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 16,
"gte": 8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 24,
"gte": 16
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 32,
"gte": 24
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 40,
"gte": 32
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"gte": 40
}
}
}
]
}
}
}
}
]
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.telephones",
"query": {
"bool": {
"should": [
{
"term": {
"personalDetails.telephones.numberType": "mobile"
}
},
{
"term": {
"personalDetails.telephones.numberType": "phone"
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.emailAddresses",
"query": {
"bool": {
"must": [
{
"exists": {
"field": "personalDetails.emailAddresses"
}
}
]
}
}
}
}
]
}
}
],
"59d79f59223b55001230e5ae": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "work"
}
},
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.potentialWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.potentialWealth.convertedValues.minValue"
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.estimatedWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.estimatedWealth.convertedValues.minValue"
}
}
}
}
]
}
},
{
"bool": {
"should": [
[
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 16,
"gte": 8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 24,
"gte": 16
}
}
}
]
}
}
}
}
]
]
}
},
{
"bool": {
"should": [
{
"terms": {
"personalDetails.generalDetails.nationalities": [
"gbr",
"british"
]
}
}
]
}
},
{
"bool": {
"should": [
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-19y",
"gte": "now-34y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-34y",
"gte": "now-49y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-49y",
"gte": "now-59y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-59y"
}
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"gender": "male"
}
},
{
"term": {
"gender": "female"
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.telephones",
"query": {
"bool": {
"should": [
{
"term": {
"personalDetails.telephones.numberType": "mobile"
}
},
{
"term": {
"personalDetails.telephones.numberType": "phone"
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.emailAddresses",
"query": {
"bool": {
"must": [
{
"exists": {
"field": "personalDetails.emailAddresses"
}
}
]
}
}
}
}
]
}
}
],
"59d62e32c75f5a0012b44a1e": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "work"
}
},
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ESP"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MCO"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.potentialWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.potentialWealth.convertedValues.minValue"
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.estimatedWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.estimatedWealth.convertedValues.minValue"
}
}
}
}
]
}
},
{
"bool": {
"should": [
[
{
"bool": {
"must_not": {
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"exists": {
"field": "wealthSummary.totalWealth.convertedValues"
}
}
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 2.8,
"gte": 0.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 4,
"gte": 2.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 8,
"gte": 4
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 16,
"gte": 8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 24,
"gte": 16
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 32,
"gte": 24
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 40,
"gte": 32
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"gte": 40
}
}
}
]
}
}
}
}
]
]
}
},
{
"bool": {
"should": [
{
"terms": {
"personalDetails.generalDetails.nationalities": [
"gbr",
"british"
]
}
},
{
"terms": {
"personalDetails.generalDetails.nationalities": [
"fra",
"french"
]
}
},
{
"terms": {
"personalDetails.generalDetails.nationalities": [
"ita",
"italian"
]
}
},
{
"terms": {
"personalDetails.generalDetails.nationalities": [
"ser",
"serbianormont"
]
}
},
{
"terms": {
"personalDetails.generalDetails.nationalities": [
"esp",
"spaniard"
]
}
}
]
}
},
{
"bool": {
"should": [
{
"range": {
"personalDetails.generalDetails.birthDate": {
"gte": "now-19y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-19y",
"gte": "now-34y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-34y",
"gte": "now-49y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-49y",
"gte": "now-59y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-59y"
}
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"gender": "male"
}
},
{
"term": {
"gender": "female"
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"terms": {
"gender": [
"male",
"female"
]
}
}
]
}
},
{
"bool": {
"must_not": {
"exists": {
"field": "gender"
}
}
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.telephones",
"query": {
"bool": {
"should": [
{
"term": {
"personalDetails.telephones.numberType": "mobile"
}
},
{
"term": {
"personalDetails.telephones.numberType": "phone"
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.emailAddresses",
"query": {
"bool": {
"must": [
{
"exists": {
"field": "personalDetails.emailAddresses"
}
}
]
}
}
}
}
]
}
}
],
"59d62e294d0559001251bacf": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.countryCode": "BHS"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BLZ"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CRI"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "DMA"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "DOM"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "SLV"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GTM"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "HTI"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "HND"
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"AGU"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BCN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BCS"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CAM"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHP"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHH"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"COA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"COL"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DIF"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DUR"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"GUA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"GRO"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"HID"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"JAL"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"MEX"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"MIC"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"MOR"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NAY"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NLE"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"OAX"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"PUE"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"QUE"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"ROO"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SLP"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SIN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SON"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"TAB"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"TAM"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"TLA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"VER"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"YUC"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"ZAC"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MEX"
}
}
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "NIC"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "PAN"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KNA"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "TCA"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "VIR"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ANT"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARB"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRB"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BMU"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BVI"
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CA-AB"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CAN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CA-BC"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CAN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CA-MB"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CAN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CA-NB"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CAN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CA-NL"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CAN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CA-NT"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CAN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CA-NS"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CAN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CA-NV"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CAN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CA-ON"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CAN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CA-PE"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CAN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CA-QC"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CAN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CA-SK"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CAN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CA-YK"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CAN"
}
}
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CYM"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GRN"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "JAM"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "STLCA"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "TTO"
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"AL"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"AK"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"AZ"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"AR"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CO"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CT"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DE"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DC"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"FL"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"GA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"HI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"ID"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"IL"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"IN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"IA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KS"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KY"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"LA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"ME"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"MD"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"MA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"MI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"MN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"MS"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"MO"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"MT"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NE"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NV"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NH"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NJ"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NM"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NY"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NC"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"ND"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"OH"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"OK"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"OR"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"PA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"RI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SC"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SD"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"TN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"TX"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"UT"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"VT"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"VA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"WA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"WV"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"WI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"WY"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"B"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"K"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"H"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"U"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"C"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"X"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"W"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"E"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"P"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"Y"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"L"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"F"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"M"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"N"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"Q"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"R"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"A"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"J"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"D"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"Z"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"S"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"G"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"V"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"T"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ARG"
}
}
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BOL"
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_ACRE"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_ALAGOAS"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_AMAPA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_AMAZONAS"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_BAHIA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_CEARA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_DISTRITO_FEDERAL"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_ESPIRITO_SANTO"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_GOIAS"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_MARANHAO"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_MATO_GROSSO"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_MATO_GROSSO_DO_SUL"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_MINAS_GERAIS"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_PARA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_PARAIBA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_PARANA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_PERNAMBUCO"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_PIAUI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_RIO_DE_JANEIRO"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_RIO_GRANDE_DO_NORTE"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_RIO_GRANDE_DO_SUL"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_RONDONIA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_RORAIMA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_SANTA_CATARINA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_SAO_PAULO"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_SERGIPE"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRA_TOCANTINS"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "BRA"
}
}
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHL"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "COL"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ECU"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GUF"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GUY"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "PRY"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "PER"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "SUR"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "URY"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "VEN"
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_ANHUI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_BEIJING"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_CHONGQING"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_FUJIAN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_GANSU"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_GUANGDONG"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_GUANGXI_ZHUANG"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_GUIZHOU"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_HAINAN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_HEBEI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_HEILONGJIANG"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_HENAN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_HUBEI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_HUNAN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_JIANGSU"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_JIANGXI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_JILIN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_LIAONING"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_NEI_MONGOL"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_NINGXIA_HUI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_QINGHAI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_SHAANXI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_SHANDONG"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_SHANGHAI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_SHANXI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_SICHUAN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_TIANJIN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_XINJIANG_UYGUR"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_XIZANG"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_YUNNAN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHN_ZHEJIANG"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "CHN"
}
}
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "HKG"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MAC"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "MNG"
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KP-HAN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "PRK"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KP-HWN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "PRK"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KP-CHA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "PRK"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KP-PYN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "PRK"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KP-PYO"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "PRK"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KP-YAN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "PRK"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-26"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-43"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-44"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-27"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-30"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-42"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-29"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-41"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-47"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-48"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-28"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-49"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-45"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-46"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-11"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KR-31"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "KOR"
}
}
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "TWN"
}
}
]
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
[
{
"bool": {
"must_not": {
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"exists": {
"field": "wealthSummary.totalWealth.convertedValues"
}
}
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 24,
"gte": 16
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 32,
"gte": 24
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 40,
"gte": 32
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"gte": 40
}
}
}
]
}
}
}
}
]
]
}
},
{
"bool": {
"should": [
{
"range": {
"personalDetails.generalDetails.birthDate": {
"gte": "now-19y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-34y",
"gte": "now-49y"
}
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"gender": "female"
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"terms": {
"gender": [
"male",
"female"
]
}
}
]
}
},
{
"bool": {
"must_not": {
"exists": {
"field": "gender"
}
}
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.telephones",
"query": {
"bool": {
"should": [
{
"term": {
"personalDetails.telephones.numberType": "phone"
}
}
]
}
}
}
}
]
}
}
],
"5a4f4f479a853500124c748c": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.countryCode": "ESP"
}
},
{
"term": {
"personalDetails.addresses.countryCode": "AND"
}
}
]
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.emailAddresses",
"query": {
"bool": {
"must": [
{
"exists": {
"field": "personalDetails.emailAddresses"
}
}
]
}
}
}
}
]
}
}
],
"5a6755119fcc4c0012bf63f1": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "work"
}
},
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
}
]
}
}
}
}
]
}
}
],
"59d7a0f4223b55001230e74e": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "work"
}
},
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.potentialWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.potentialWealth.convertedValues.minValue"
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.estimatedWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.estimatedWealth.convertedValues.minValue"
}
}
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.telephones",
"query": {
"bool": {
"should": [
{
"term": {
"personalDetails.telephones.numberType": "mobile"
}
},
{
"term": {
"personalDetails.telephones.numberType": "phone"
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.emailAddresses",
"query": {
"bool": {
"must": [
{
"exists": {
"field": "personalDetails.emailAddresses"
}
}
]
}
}
}
}
]
}
}
],
"59ba3f6d1e45790011f706fe": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NY"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "USA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"FRA_ILE_DE_FRANCE"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "FRA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"GBR_GREATER_LONDON"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
}
]
}
}
]
}
}
}
}
]
}
}
],
"59b901f9ababf600118d7346": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
}
]
}
}
}
}
]
}
}
],
"5a673c98e811220012b8f688": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "home"
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BDF"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BRK"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"BKM"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CAM"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CHS"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CLV"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CON"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DUR"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"CMA"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DBY"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DEV"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"DOR"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SXE"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"ESS"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"GLS"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"GBR_GREATER_LONDON"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"GTM"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"HAM"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"HWR"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"HRT"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"HUM"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"IOW"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"KEN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"LAN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"LEI"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"LIN"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"MSY"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NFK"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NYK"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NTH"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"GBR_NORTHERN_IRELAND"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NBL"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"NTT"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"OXF"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"GBR_SCOTLAND"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SAL"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SOM"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SYK"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"STS"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SFK"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SRY"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"TWR"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"GBR_WALES"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"WAR"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"WMD"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"SXW"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"WYK"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"WIL"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "GBR"
}
}
]
}
}
]
}
}
]
}
}
}
}
]
}
}
],
"59d7a1a1223b55001230e7fa": [
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.addresses",
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"term": {
"personalDetails.addresses.typeCode": "work"
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"1"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"2"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"3"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"4"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"5"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"6"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"7"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"8"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"9"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"10"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"11"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"12"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"13"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"14"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"15"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"16"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"17"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"18"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"19"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"20"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
},
{
"bool": {
"must": [
{
"terms": {
"personalDetails.addresses.stateCode": [
"21"
]
}
},
{
"term": {
"personalDetails.addresses.countryCode": "ITA"
}
}
]
}
}
]
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.potentialWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.potentialWealth.convertedValues.minValue"
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "liquidityEvents.estimatedWealth.convertedValues",
"query": {
"exists": {
"field": "liquidityEvents.estimatedWealth.convertedValues.minValue"
}
}
}
}
]
}
},
{
"bool": {
"should": [
[
{
"bool": {
"must_not": {
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"exists": {
"field": "wealthSummary.totalWealth.convertedValues"
}
}
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 0.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 2.8,
"gte": 0.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 4,
"gte": 2.8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 8,
"gte": 4
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 16,
"gte": 8
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 24,
"gte": 16
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 32,
"gte": 24
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"lt": 40,
"gte": 32
}
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "wealthSummary.totalWealth.convertedValues",
"query": {
"bool": {
"must": [
{
"term": {
"wealthSummary.totalWealth.convertedValues.currencyCode": {
"value": "GBP"
}
}
},
{
"range": {
"wealthSummary.totalWealth.convertedValues.minValue": {
"gte": 40
}
}
}
]
}
}
}
}
]
]
}
},
{
"bool": {
"should": [
{
"terms": {
"personalDetails.generalDetails.nationalities": [
"ita",
"italian"
]
}
}
]
}
},
{
"bool": {
"should": [
{
"range": {
"personalDetails.generalDetails.birthDate": {
"gte": "now-19y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-19y",
"gte": "now-34y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-34y",
"gte": "now-49y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-49y",
"gte": "now-59y"
}
}
},
{
"range": {
"personalDetails.generalDetails.birthDate": {
"lte": "now-59y"
}
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"gender": "male"
}
},
{
"term": {
"gender": "female"
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.telephones",
"query": {
"bool": {
"should": [
{
"term": {
"personalDetails.telephones.numberType": "mobile"
}
},
{
"term": {
"personalDetails.telephones.numberType": "phone"
}
}
]
}
}
}
},
{
"nested": {
"ignore_unmapped": true,
"path": "personalDetails.emailAddresses",
"query": {
"bool": {
"must": [
{
"exists": {
"field": "personalDetails.emailAddresses"
}
}
]
}
}
}
}
]
}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment