OK i just figure it out, Do there is a more effcient query?
{
"from": 0,
"size": 10,
"query": {
"filtered": {
"query": {
"multi_match": {
"query": "rob",
"fields": [
"LegalName^70",
"LegalName.raw^70",
"Alias^15",
"RelationshipName^12",
"Address^10",
"NaicsCode^1",
"Phone^10",
"LesseeNumber^1",
"FullName^40",
"FirstName^40",
"LastName^40",
"FullName.raw^50",
"Relationship^15",
"DobYear^5"
],
"tie_breaker": 0.3,
"operator": "or",
"type": "best_fields"
}
},
"filter": {
"bool": {
"should": [
{
"term": {
"ContentStatus": "1"
}
}
],
"must": {
"nested": {
"path": "SecurityScope",
"filter": {
"bool": {
"must": [
{
"term": {
"SecurityScope.FunderId": "1"
}
}
]
}
}
}
}
}
}
}
},
"highlight": {
"pre_tags": [
"<em>"
],
"post_tags": [
"<\/em>"
],
"tags_schema": "styled",
"fragment_size": "150",
"number_of_fragments": "3",
"order": "score",
"fields": {
"LegalName": {
},
"LegalName.raw": {
},
"Alias": {
},
"RelationshipName": {
},
"Address": {
},
"NaicsCode": {
},
"Phone": {
},
"LesseeNumber": {
},
"FullName": {
},
"FirstName": {
},
"LastName": {
},
"FullName.raw": {
},
"Relationship": {
},
"DobYear": {
}
}
}
}
On Thursday, May 28, 2015 at 3:31:29 PM UTC-4, Yusbel Garcia wrote:
>
> I'm having parse error when posting a filtered nested object during
> search, bellow my posting data and the indexed data.
>
> Data posted:
>
> {
> "from": 0,
> "size": 10,
> "query": {
> "filtered": {
> "query": {
> "multi_match": {
> "query": "ro",
> "fields": [
> "LegalName^70",
> "LegalName.raw^70",
> "Alias^15",
> "RelationshipName^12",
> "Address^10",
> "NaicsCode^1",
> "Phone^10",
> "LesseeNumber^1",
> "FullName^40",
> "FirstName^40",
> "LastName^40",
> "FullName.raw^50",
> "Relationship^15",
> "DobYear^5"
> ],
> "tie_breaker": 0.3,
> "operator": "or",
> "type": "best_fields"
> }
> },
> *"filter": {
> "nested": {
> "path": "SecurityScope",
> "filter": {
> "bool": {
> "must": [
> {
> "term": {
> "SecurityScope.FunderId": "1"
> }
> }
> ],
> "should": [
> {
> "term": {
> "ContentStatus": "1"
> }
> }
> ]
> }
> }
> }
> }
> }*
> },
> "highlight": {
> "pre_tags": [
> "<em>"
> ],
> "post_tags": [
> "<\/em>"
> ],
> "tags_schema": "styled",
> "fragment_size": "150",
> "number_of_fragments": "3",
> "order": "score",
> "fields": {
> "LegalName": {
>
> },
> "LegalName.raw": {
>
> },
> "Alias": {
>
> },
> "RelationshipName": {
>
> },
> "Address": {
>
> },
> "NaicsCode": {
>
> },
> "Phone": {
>
> },
> "LesseeNumber": {
>
> },
> "FullName": {
>
> },
> "FirstName": {
>
> },
> "LastName": {
>
> },
> "FullName.raw": {
>
> },
> "Relationship": {
>
> },
> "DobYear": {
>
> }
> }
> }
> }
>
>
>
> Data Indexed:
>
>
> {
> "_index": "intellisearch",
> "_type": "business",
> "_id": "33009",
> "_score": 1,
> "_source": {
> "Identifier": "33009",
> "ContentStatus": 1,
> "Links": null,
> "ApplicantId": 33009,
> "ApplicantTypeCode": "COM",
> "LegalName": "INTEGRATED INDUSTRIAL SUPPLY INC",
> "Alias": "INTEGRATED INDUSTRIAL SUPPLY INC",
> "BusinessName": "INTEGRATED INDUSTRIAL SUPPLY INC",
> "OperationName": "",
> "RelationshipName": "",
> "Address": "1337 W BETTERAVIA RD SANTA MARIA CALIFORNIA USA",
> "AddressLine1": "1337 W BETTERAVIA RD",
> "AddressLine2": "",
> "AddressLine3": "",
> "City": "SANTA MARIA",
> "Province": "CALIFORNIA",
> "Country": "USA",
> "NaicsCode": "0",
> "NaicsDescription": "N/A",
> "Phone": "8059258468",
> "LesseeNumber": "",
> "Score": 0,
> "BusinessStartDateYear": "1900",
> "ContentDocType": 2,
> "Extended": null,
> "SecurityScope": {
> "FunderId": "1"
> }
> }
>
>
>
> Can you give me a hint?
>
>
>
> Thank you,
>
> Yusbel
>
>
>
>
>
>
--
Please update your bookmarks! We have moved to https://discuss.elastic.co/
---
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/2c2eefb3-6686-43b4-abb6-e40b82e9dedf%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
