Getting static lookup value with id

Elastic Stack Kibana
1

Hi,
I am trying to get some data from elastic, I have added a static look up for customerId (123 -> abc ....)in kibana, i am using the below query to get the data but it returns the id and not the look up data, is there a way i can get the customerId and the lookup data that i have added as well,
i am using below query in go to get the data.

GET _search
{
  "aggs": {
    "rec": {
      "terms": {
        "field": "customerId.keyword",
        "order": {
          "_count": "desc"
        },
        "size": 15
      }
    }
  },
  "size": 0,
  
  "script_fields": {},
  "stored_fields": [
    "*"
  ],
  "runtime_mappings": {},
  "_source": {
    "excludes": []
  },
  "query": {
    "bool": {
      "must": [],
      "filter": [
        {
          "match_all": {}
        },
        {
          "match_phrase": {
            "status": "Active"
          }
        },
        {
          "range": {
            "dateTime": {
              "gte": "2022-02-14T09:33:16.630Z",
              "lte": "2022-02-14T09:48:16.630Z",
              "format": "strict_date_optional_time"
            }
          }
        }
      ],
      "should": [],
      "must_not": []
    }
  }
}

Thanks in advance for your time

2

Hi there,
unfortunately, static lookup is a Kibana formatter so it cannot be accessed when hitting Elasticsearch directly.

3

Hi,
ok thank you, any api or query that can help me get the static lookup from kibana ?

4

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