# Like search on multiple indexes on elastic search

**URL:** <https://discuss.elastic.co/t/like-search-on-multiple-indexes-on-elastic-search/304165>\
**Category:** Elasticsearch\
**Created:** [May 7, 2022, 4:39am UTC](https://discuss.elastic.co/t/like-search-on-multiple-indexes-on-elastic-search/304165 "2022-05-07T04:39:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rajesh\_Kumar3](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rajesh_kumar3/32/99210_2.png) [@Rajesh\_Kumar3](https://discuss.elastic.co/u/Rajesh_Kumar3)\
**Post date:** [May 7, 2022, 4:39am UTC](https://discuss.elastic.co/t/like-search-on-multiple-indexes-on-elastic-search/304165/1 "2022-05-07T04:39:41Z")

</div>

Hi,

I stuck on like searching on multiple indexes on Elasticsearch. I am using a query string and must to extract data for the particular user.

Example JSON  
index "tasks"

{  
"channelName": "Weekly Task-(HT-01030284)",  
"participants": [  
{  
"id": 4361,  
"channelId": 12053,  
"sfdcId": "0034z00002g0c3GAAQ",  
"firstName": "Mayank",  
"lastName": "Maheshwari",  
"profileImage": "",  
"gender": "Male",  
"isDeleted": false  
}  
]  
}

Applying code.

GET /tasks/\_search  
{  
"query": {  
"bool": {  
"must": [  
{  
"query\_string": {  
"query": "HT-01030284",  
"fields": [  
"channelName"  
]  
}  
},  
{  
"match": {  
"participants.sfdcId": "0034z00002g0c3GAAQ"  
}  
}  
]  
}  
}  
}

But in some words search is not working. Please help me to write a query that will search as SQL does with a like.

---

<div class="post-metadata">

**Author:** ![RabBit\_BR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rabbit_br/32/82261_2.png) [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\
**Post date:** [May 7, 2022, 1:00pm UTC](https://discuss.elastic.co/t/like-search-on-multiple-indexes-on-elastic-search/304165/2 "2022-05-07T13:00:53Z")

</div>

Hi.

Give more exemples to understand you problem.  
What terms not produce results?  
Show your mapping.

---

<div class="post-metadata">

**Author:** ![Rajesh\_Kumar3](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rajesh_kumar3/32/99210_2.png) [@Rajesh\_Kumar3](https://discuss.elastic.co/u/Rajesh_Kumar3)\
**Post date:** [May 9, 2022, 5:08am UTC](https://discuss.elastic.co/t/like-search-on-multiple-indexes-on-elastic-search/304165/3 "2022-05-09T05:08:46Z")

</div>

{  
"tasks" : {  
"mappings" : {  
"properties" : {  
"channelId" : {  
"type" : "long"  
},  
"channelName" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"channelsfdcid" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"createdAt" : {  
"type" : "date"  
},  
"documentUrl" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"documenturl" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"firstName" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"id" : {  
"type" : "long"  
},  
"initatedBy" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"isActive" : {  
"type" : "boolean"  
},  
"isEscalation" : {  
"type" : "boolean"  
},  
"isFavorite" : {  
"type" : "boolean"  
},  
"isForward" : {  
"type" : "boolean"  
},  
"isRead" : {  
"type" : "boolean"  
},  
"isReply" : {  
"type" : "boolean"  
},  
"lastName" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"mainMessageReplyConversation" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"message" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"messageId" : {  
"type" : "long"  
},  
"name" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"originalPost" : {  
"type" : "boolean"  
},  
"parentConversation" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"parentReplyConversation" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"participants" : {  
"properties" : {  
"channelId" : {  
"type" : "long"  
},  
"firstName" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"gender" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"id" : {  
"type" : "long"  
},  
"isDeleted" : {  
"type" : "boolean"  
},  
"lastName" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"profileImage" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"sfdcId" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
}  
}  
},  
"pgMOTasks" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"priority" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"profileImage" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"sender" : {  
"type" : "long"  
},  
"sfdcId" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"task" : {  
"properties" : {  
"account" : {  
"properties" : {  
"name" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"sfdcId" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
}  
}  
},  
"assignment" : {  
"properties" : {  
"pgMOGroups" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"pgMOTasks" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"sfdcId" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"worker" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
}  
}  
},  
"businessRequestor" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"businessRequestorWorker" : {  
"properties" : {  
"name" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"sfdcId" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
}  
}  
},  
"completePercentage" : {  
"type" : "long"  
},  
"dueDate" : {  
"type" : "date"  
},  
"milestone" : {  
"properties" : {  
"milestoneNo" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"name" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"sfdcId" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
}  
}  
},  
"name" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"parentEscalatedTask" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"pgMOMilestones" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"pgMOProjects" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"priority" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"problemResolutionStatus" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"project" : {  
"properties" : {  
"category" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"projectName" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"projectNo" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"projectType" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"recordTypeId" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"sfdcId" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"subCatergory" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
}  
}  
},  
"requestType" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"requestor" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"requestorWorker" : {  
"properties" : {  
"name" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"sfdcId" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
}  
}  
},  
"sfdcId" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"startDate" : {  
"type" : "date"  
},  
"taskNo" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"taskNumber" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"taskStatus" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"taskType" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
}  
}  
},  
"taskId" : {  
"type" : "long"  
},  
"title" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"type" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"userId" : {  
"type" : "long"  
},  
"worker" : {  
"properties" : {  
"contact" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
},  
"sfdcId" : {  
"type" : "text",  
"fields" : {  
"keyword" : {  
"type" : "keyword",  
"ignore\_above" : 256  
}  
}  
}  
}  
}  
}  
}  
}  
}

Terms like "interview" when I pass "inter" then no result and also for "requisition" when i pass "requi" then no result found.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 6, 2022, 5:09am UTC](https://discuss.elastic.co/t/like-search-on-multiple-indexes-on-elastic-search/304165/4 "2022-06-06T05:09:28Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.