Search for a value and return all respective fields

Elastic Stack Elasticsearch
1

Hi, i have a lot of content in my Elasticsearch, 1 index, 100 types.

Example:
DOC 1:
"_index": "test", "_type": "type1", "_id": "0000000001", "_score": 5.499016, "_source": { "facebook": "example111", "twitter": "yyyyy", "instagram": "ccccc"

DOC 2:
"_index": "test", "_type": "type2", "_id": "0000000001", "_score": 5.499016, "_source": { "facebook42424": "example111", "elastic": "zzzzzz", "google": "aaaaaaa"

DOC 3:
"_index": "test", "_type": "type3", "_id": "0000000001", "_score": 5.499016, "_source": { "facebook2332": "example111", "dsa": 87878787, "sdasda": "bbbbb"

I search for value "example111" in all types and it returns all documents that contain that value, but you must consider that my documents have many fields.
What I'm trying to do is searching for a value and get all respective fields. I have same values but different fields and i want to see where value "example111" is present.
PS: i dont know the fields name, i know only the values (i cant inspect all documents to see their respective fields.)
In the case above i want to return:

  1. Value "example111" is present in: doc_type 1 , field: facebook
  2. Value "example111" is present in: doc_type 2 , field: facebook42424
  3. Value "example111" is present in: doc_type 3 , field: facebook2332

Can someone help me please? Thank you in advance

2

any help?

3

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