elasticsearch query

elasticsearch.json

GET _search
{
  "query": {
    "match_all": {}
  }
}

GET _cat/indices

GET dev-content

GET dev-content/_search/?size=1000
{
  "query": {
    "match_all": {}
  }
}


GET dev-content/_count
{
  "query": {
    "match": {
      "quillHTMLs.quillHTML": "<p>"
    }
  }
}


GET dev-content/_search
{
  "query": {
    "match": {
      "quillHTMLs.quillHTML": "<p>"
    }
  }
}


GET dev-content/_search
{
  "query": {
    "bool": { 
      "must_not": [
        {
          "match": {
        "quillHTMLs.quillHTML": "<p>"
      }
        }
      ]
    }
  }
}


GET dev-content/_search
{
  "query": {
    "bool": { 
      "filter": { "term": { "pageID": 238 } }
      , "should": [
        {
          "match": {
            "context.tokenizedText": {
              "query": "หิว"
            }
          }
        }
      ],
      "minimum_should_match": 0
    }
  }
}

GET dev-content/_search/?size=100
{
  "query": {
    "bool": {
     "should": [
       {
         "term": {
           "context.text": {
             "value": "หิว"
           }
         }
       }
     ]
   }
  },
  "sort": [
    {
      "@timestamp": {
        "order": "asc"
      }
    }
  ]
}

GET dev-content/_search/?size=100
{
  "query": {
    "match": {
      "quillHTMLs.quillHTML": "<p>"
    }
  }
}

POST content/_doc
{
  "pageID": 238,
  "webPageID": "60e8271554cca90f35aee510",
  "webPageName": {
    "name": "webPageName",
    "cultureUI": "TH"
  },
  "context": [
    {
       "type": "cms-next-cms-content-text-rendering",
      "text": "การเวลาหมุนไป",
      "tokenizedText": "การ เวลา หมุน ไป",
      "cultureUI": "TH"
    }
  ]
}


POST content/_update_by_query
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "pageID": 238
          }
        },
        {
          "match": {
             "webPageID": "60e8271554cca90f35aee510"
          }
        }
      ]
    }
  },
  "webPageName": {
    "name": "Web Page Name 1",
    "cultureUI": "TH"
  },
  "context": [
    {
       "type": "cms-next-cms-content-text-rendering",
      "text": "การเวลาหมุนไป",
      "tokenizedText": "การ เวลา หมุน ไป",
      "cultureUI": "TH"
    },
    {
       "type": "cms-next-cms-content-text-rendering",
      "text": "ไม่เข้าใจว่าทำไม",
      "tokenizedText": "ไม่ เข้า ใจ ว่า ทำไม",
      "cultureUI": "TH"
    }
  ]
}



GET content/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "pageID": 238
          }
        }
      ],
      "should": [
        {
          "term": {
            "webPageName.name": {
              "value": "การ"
            }
          }
        },
        {
          "term": {
            "context.tokenizedText": {
              "value": ""
            }
          }
        }
      ]
    }
  }
}

PUT content
{
  "settings": {
    "index": {
      "analysis": {
        "analyzer": {
          "my_icu_analyzer": {
            "tokenizer": "icu_tokenizer"
          }
        }
      }
    }
  },
  "mappings": {
    "properties": {
      "@timestamp": {
        "type": "date"
      },
      "pageID": {
        "type": "integer",
        "index": true
      },      
      "webPageID": {
        "type": "keyword",
        "index": true,
        "ignore_above": 24
      },
      "webPageName": {
        "type": "nested",
        "properties": {
          "name": {
              "type": "text",
              "analyzer": "my_icu_analyzer",
              "index": true
          },
          "cultureUI" : {
            "type": "keyword",
            "ignore_above": 4,
            "index": true
          }
        }
      },
      "context": {
        "type": "nested",
        "properties": {
          "payload": {
            "type": "text",
            "analyzer": "my_icu_analyzer",
            "index": true
          },
          "payloadNLP": {
            "type": "text",
            "index": true
          },
          "cultureUI" : {
            "type": "keyword",
            "ignore_above": 4,
            "index": true
          }
        }
      }
    }
  }
}