# Deleting Record from ES

**URL:** <https://discuss.elastic.co/t/deleting-record-from-es/38238>\
**Category:** Elasticsearch\
**Created:** [January 1, 2016, 6:33am UTC](https://discuss.elastic.co/t/deleting-record-from-es/38238 "2016-01-01T06:33:33Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sivaprakash\_Shanmuga](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@Sivaprakash\_Shanmuga](https://discuss.elastic.co/u/Sivaprakash_Shanmuga)\
**Post date:** [January 1, 2016, 6:33am UTC](https://discuss.elastic.co/t/deleting-record-from-es/38238/1 "2016-01-01T06:33:33Z")

</div>

Hi

I have indexed data in Elastic Search as

> {"\_index":"school","\_type":"student","\_id":"AVHKjoOLfAoTEUc3htss","\_score":1.0,"\_source":{  
> "schoolId" : "1952",  
> "studentId" : "1053",  
> "createdDate" : "2009-11-15T14:12:12" ,  
> "updatedDate" : "2009-11-15T14:12:12",  
> "location": {  
> "lat": 41.12,  
> "lon": -71.34  
> }  
> }

I'm trying to delete the above record using

> [http://localhost:9400/schoolId/\_query](http://localhost:9400/schoolId/_query)

> {"query" : {  
> "term" : { "schoolId" : "1952" }  
> }}

but it is not removing that particular record (schoolId is Unique). However, If I use the below query it removes.

> [http://localhost:9400/schoolId/\_query](http://localhost:9400/schoolId/_query)

> {"query" : {  
> "term" : { "\_id" : "AVHKjoOLfAoTEUc3htss" }  
> }}

Is there anything wrong in my first query.

---

<div class="post-metadata">

**Author:** ![kartheek91](https://avatars.discourse-cdn.com/v4/letter/k/cc9497/32.png) [@kartheek91](https://discuss.elastic.co/u/kartheek91)\
**Post date:** [January 1, 2016, 7:58am UTC](https://discuss.elastic.co/t/deleting-record-from-es/38238/2 "2016-01-01T07:58:43Z")

</div>

Yes,actually you are trying using wrong syntax.

curl -XGET '[http://localhost:9200/school/student/\_delete](http://localhost:9200/school/student/_delete)  
{  
"\_id" : "AVHKjoOLfAoTEUc3htss"  
}

---

<div class="post-metadata">

**Author:** ![Sivaprakash\_Shanmuga](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@Sivaprakash\_Shanmuga](https://discuss.elastic.co/u/Sivaprakash_Shanmuga)\
**Post date:** [January 1, 2016, 8:43am UTC](https://discuss.elastic.co/t/deleting-record-from-es/38238/3 "2016-01-01T08:43:11Z")

</div>

It is not working also I want to use "schoolId" as parameter not \_id to delete the document.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [January 1, 2016, 10:13am UTC](https://discuss.elastic.co/t/deleting-record-from-es/38238/4 "2016-01-01T10:13:00Z")

</div>

TBH you should better use your schoolId as the document id. It will be more efficient for updates/removes/get...

---

<div class="post-metadata">

**Author:** ![Sivaprakash\_Shanmuga](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@Sivaprakash\_Shanmuga](https://discuss.elastic.co/u/Sivaprakash_Shanmuga)\
**Post date:** [January 1, 2016, 1:24pm UTC](https://discuss.elastic.co/t/deleting-record-from-es/38238/5 "2016-01-01T13:24:24Z")

</div>

YES that works fine. Just in case if I have to more constraints what should I do ? I tried the below but didnt work.

> {"query" : {  
> "and" : [  
> {"term" : { "\_id" : "1952" }},  
> {"term" : { "studentId" : "1053" }}]  
> }  
> }

---

<div class="post-metadata">

**Author:** ![Sivaprakash\_Shanmuga](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@Sivaprakash\_Shanmuga](https://discuss.elastic.co/u/Sivaprakash_Shanmuga)\
**Post date:** [January 2, 2016, 1:33pm UTC](https://discuss.elastic.co/t/deleting-record-from-es/38238/6 "2016-01-02T13:33:54Z")

</div>

Got it working !! Thank You.

---

<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:** [July 5, 2017, 11:27pm UTC](https://discuss.elastic.co/t/deleting-record-from-es/38238/7 "2017-07-05T23:27:27Z")

</div>