Eu tenho duas consultas, duas selecionadas em um documento de índice. os "aplicativos" são um caminho aninhado em "candidato". Procuro entre o campo workexp, summary , mas os documentos contém o valor no Felds, ele não aparece na consulta 1 abaixo. Sempre aparece na resposta da consulta 2. consulta 1:
{
"nested": {
"path": "applications",
"query": {
"bool": {
"must": [
{
"simple_query_string": {
"default_operator": "and",
"fields": [
"applications.workexp"
],
"query": "(Tableau) Or (Tableau) Or (Tableau workbooks)"
}
},
{
"simple_query_string": {
"default_operator": "and",
"fields": [
"applications.summary"
],
"query": "(Tableau) Or (Tableau) Or (Tableau workbooks)"
}
},
{
"match": {
"applications.forreqid": {
"query": "FH-REQ-3"
}
}
}
]
}
}
}
}
consulta 2
{
"nested": {
"path": "applications",
"query": {
"bool": {
"must": [
{
"match": {
"applications.forreqid": {
"query": "FH-REQ-3"
}
}
}
],
"must_not": [
{
"simple_query_string": {
"default_operator": "and",
"fields": [
"applications.workexp"
],
"query": "(Tableau) Or (Tableau) Or (Tableau workbooks)"
}
},
{
"simple_query_string": {
"default_operator": "and",
"fields": [
"applications.summary"
],
"query": "(Tableau) Or (Tableau) Or (Tableau workbooks)"
}
}
]
}
}
}
}
O documento que espero receber na resposta
{
createdby : [email protected],
applications : [
{
applnid : yy,
summary : top and Tableau Server.· Involved in dashboard test cases creation and execution, prepared the understanding and function/ process flow documents on various dashboards for the end users.· Created technical specifications document as well as functional documents in support of the user requirements.· Generate Tableau reports to analyze data from multiple data sources like Oracle, SQL Server, Excel, Flat Files, etc · Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter and calculations · Having experience in Tableau Desktop Creating Sets, Group, Sort, Parameter, Quick filters, Context Filters, Data blending, Joins and Calculations etc.Experience Details · Educational Detai,
workexp : Procurement of billing the project and Project lead · The solution involves in creating dashboards and stories that depict different levels and stages.· The very first is a managerial dashboard to give quick overview of the Categories and their overview among different geographical areas, trends and comparisons using Map Charts, Pies, Stacked Bars, Scatter Plots etc.· The second one concentrates more on slicing and dicing the inventory and sales data using Dual Axis Charts, Various line charts, Waterfall charts etc.· The last one is a blend of Calculated Fields, Table Calculations and a bit of LODs to answer different types of the requirements of the client. Role : Tableau Developer Revenue Growth in % · Used Filters to know Department wise Sales and their Cost for Particular Periods and draft various charts using Show Me in Tableau Desktop.,
education : null,
certtrainings : null,
gaps : null,
skilltags : null,
forreqid : FH-REQ-3,
uploadedbyuser : null
}
]
}
Código de consulta abaixo -
Query workExQuery = SimpleQueryStringQuery.of(q -> q.query(finalQuery)
.fields(Arrays.asList("applications.workexp")).defaultOperator(Operator.And))._toQuery();
queries.add(workExQuery);
Query summaryQuery = SimpleQueryStringQuery.of(q -> q.query(finalQuery)
.fields(Arrays.asList("applications.summary")).defaultOperator(Operator.And))._toQuery();
queries.add(summaryQuery);
Formação da consulta 2:
Query query = Query.of(q -> q.nested(p -> p.path("applications").query(b -> b.bool(bq -> bq.mustNot(queries)))));
Consulta Final
esClient.search(s -> s.index("candidature").query(query), Someclass.class);
Formação da consulta 1:
Query query = Query.of(q -> q.nested(p -> p.path("applications").query(b -> b.bool(bq -> bq.must(queries)))));
Mapeamentos para o campo em java
@Field(type = FieldType.Keyword, name = "applnid")
private String applnid;
@Field(type = FieldType.Text, name = "summary")
private String summary;
@Field(type = FieldType.Text, name = "skills")
private String skills;
@Field(type = FieldType.Text, name = "employers")
private String employers;
@Field(type = FieldType.Integer, name = "totalexperienceinyears")
private String totalexperienceinyears;
@Field(type = FieldType.Text, name = "workexp")
private String workexp;
@Field(type = FieldType.Text, name = "education")
private String education;
@Field(type = FieldType.Text, name = "certtrainings")
private String certtrainings;
@Field(type = FieldType.Integer, name = "gaps")
private String gaps;
@Field(type = FieldType.Text, name = "skilltags")
private String skilltags;
@Field(type = FieldType.Keyword, name = "forreqid")
private String forreqid;
@Field(type = FieldType.Keyword, name = "uploadedbyuser")
private String uploadedbyuser;
Mapeamentos da consulta curl elástica
{
"candidature": {
"aliases": {},
"mappings": {
"properties": {
"_class": {
"type": "keyword",
"index": false,
"doc_values": false
},
"applications": {
"type": "nested",
"include_in_parent": true,
"properties": {
"_class": {
"type": "keyword",
"index": false,
"doc_values": false
},
"applnid": {
"type": "keyword"
},
"certtrainings": {
"type": "text"
},
"education": {
"type": "text"
},
"employers": {
"type": "text"
},
"forreqid": {
"type": "keyword"
},
"gaps": {
"type": "integer"
},
"skills": {
"type": "text"
},
"skilltags": {
"type": "text"
},
"summary": {
"type": "text"
},
"totalexperienceinyears": {
"type": "integer"
},
"uploadedbyuser": {
"type": "keyword"
},
"workexp": {
"type": "text"
}
}
},
"candidateId": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"contactnumber": {
"type": "keyword"
},
"createdby": {
"type": "keyword"
},
"email": {
"type": "keyword"
},
"fororg": {
"type": "keyword"
},
"name": {
"type": "text"
}
}
},
"settings": {
"index": {
"routing": {
"allocation": {
"include": {
"_tier_preference": "data_content"
}
}
},
"refresh_interval": "1s",
"number_of_shards": "1",
"provided_name": "candidature",
"creation_date": "1694872335334",
"store": {
"type": "fs"
},
"number_of_replicas": "1",
"uuid": "9cRKu-TLRsGfwuKn2UTbWg",
"version": {
"created": "8080299"
}
}
}
}
}