Use the bool query in TairSearch to perform compound queries

Sample code

1. Create an index.

   TFT.CREATEINDEX key '{
       "mappings": {
           "properties": {
               "A": { "type": "keyword" },
               "B": { "type": "keyword" },
               "C": { "type": "keyword" }
           }
       }
   }'

2. Add document data.

   TFT.ADDDOC key '{
       "A": "a",
       "B": "b",
       "C": "c"
   }'

3. Query data.

   Example 1: SELECT A = a and B = b

   TFT.SEARCH key '{
       "query": {
           "bool" : {
                "must": [
                    { "term": { "A": "a" } },
                    { "term": { "B": "b" } }
                ]
            }
       }
   }'

   Example 2: SELECT A = a or B = b

   TFT.SEARCH key '{
       "query": {
           "bool": {
                "should": [
                    { "term": { "A": "a" } },
                    { "term": { "B": "b" } }
                ]
            }
       }
   }'

   Example 3: SELECT A = a and B != b

   TFT.SEARCH key '{
       "query": {
           "bool": {
               "must": [
                    { "term": { "A": "a" } }
               ],
               "must_not": [
                    { "term": { "B": "b" } }
               ]
           }
       }
   }'

   Example 4: SELECT (A = a and B = b) or C = c

   TFT.SEARCH key '{
       "query": {
           "bool" : {
               "should": [
                   {
                       "bool": {
                           "must": [
                                { "term": { "A": "a" } },
                                { "term": { "B": "b" } }
                            ]
                       }
                   },
                   { "term": { "C": "c" }  }
               ]
           }
       }
   }'