ES reqexp query not working

Elastic Stack Elasticsearch
1

Hi all,

We are using the query filtered term to search the document in item index,

GET /es_item/item/_search
{
"query": {
"filtered": {
"filter": {
"term": {
"_id": "16404262_5431"
}
}
}
}
}

But the same query with regexp inside the term filter are not working as expected and getting the below error,
Parse Failure [Failed to parse source [{
"query": {
"filtered": {
"filter": {
"term": {
"regexp": {
"id": "16404262*"
}
}
}
}
}
}
]]]; nested: QueryParsingException[[ogrds_item] [term] filter does not support [_id]]; }]",

GET /es_item/item/_search
{
"query": {
"filtered": {
"filter": {
"term": {
"regexp": {
"id": "16404262*"
} } } }

Can any one help us to achieve this?

Thanks,
Ganeshbabu

2

Hey,

confused here. Your query uses id, but the error message shows _id. are you sure you didnt mix up those two fields?

--Alex