elasticsearch常用查询

妖狐艹你老母 2022-05-26 00:44 257阅读 0赞

<table>      
 <tbody> 
  <tr> 
   <td>关键字</td> 
   <td>查询方法</td> 
   <td>Elasticsearch 查询语句</td> 
  </tr> 
  <tr> 
   <td>And</td> 
   <td>findByNameAndPrice</td> 
   <td>{"bool" : {"must" : [ {"field" : {"name" : "?"}}, {"field" : {"price" : "?"}} ]}}</td> 
  </tr> 
  <tr> 
   <td>Or</td> 
   <td>findByNameOrPrice</td> 
   <td>{"bool" : {"should" : [ {"field" : {"name" : "?"}}, {"field" : {"price" : "?"}} ]}}</td> 
  </tr> 
  <tr> 
   <td>Is</td> 
   <td>findByName</td> 
   <td>{"bool" : {"must" : {"field" : {"name" : "?"}}}}</td> 
  </tr> 
  <tr> 
   <td>Not</td> 
   <td>findByNameNot</td> 
   <td>{"bool" : {"must_not" : {"field" : {"name" : "?"}}}}</td> 
  </tr> 
  <tr> 
   <td>Between</td> 
   <td>findByPriceBetween</td> 
   <td>{"bool" : {"must" : {"range" : {"price" : {"from" : ?,"to" : ?,"include_lower" : true,"include_upper" : true}}}}}</td> 
  </tr> 
  <tr> 
   <td>LessThanEqual</td> 
   <td>findByPriceLessThan</td> 
   <td>{"bool" : {"must" : {"range" : {"price" : {"from" : null,"to" : ?,"include_lower" : true,"include_upper" : true}}}}}</td> 
  </tr> 
  <tr> 
   <td>GreaterThanEqual</td> 
   <td>findByPriceGreaterThan</td> 
   <td>{"bool" : {"must" : {"range" : {"price" : {"from" : ?,"to" : null,"include_lower" : true,"include_upper" : true}}}}}</td> 
  </tr> 
  <tr> 
   <td>Before</td> 
   <td>findByPriceBefore</td> 
   <td>{"bool" : {"must" : {"range" : {"price" : {"from" : null,"to" : ?,"include_lower" : true,"include_upper" : true}}}}}</td> 
  </tr> 
  <tr> 
   <td>After</td> 
   <td>findByPriceAfter</td> 
   <td>{"bool" : {"must" : {"range" : {"price" : {"from" : ?,"to" : null,"include_lower" : true,"include_upper" : true}}}}}</td> 
  </tr> 
  <tr> 
   <td>Like</td> 
   <td>findByNameLike</td> 
   <td>{"bool" : {"must" : {"field" : {"name" : {"query" : "?*","analyze_wildcard" : true}}}}}</td> 
  </tr> 
  <tr> 
   <td>StartingWith</td> 
   <td>findByNameStartingWith</td> 
   <td>{"bool" : {"must" : {"field" : {"name" : {"query" : "?*","analyze_wildcard" : true}}}}}</td> 
  </tr> 
  <tr> 
   <td>EndingWith</td> 
   <td>findByNameEndingWith</td> 
   <td>{"bool" : {"must" : {"field" : {"name" : {"query" : "*?","analyze_wildcard" : true}}}}}</td> 
  </tr> 
  <tr> 
   <td>Contains/Containing</td> 
   <td>findByNameContaining</td> 
   <td>{"bool" : {"must" : {"field" : {"name" : {"query" : "?","analyze_wildcard" : true}}}}}</td> 
  </tr> 
  <tr> 
   <td>In</td> 
   <td>findByNameIn(Collection&lt;String&gt;names)</td> 
   <td>{"bool" : {"must" : {"bool" : {"should" : [ {"field" : {"name" : "?"}}, {"field" : {"name" : "?"}} ]}}}}</td> 
  </tr> 
  <tr> 
   <td>NotIn</td> 
   <td>findByNameNotIn(Collection&lt;String&gt;names)</td> 
   <td>{"bool" : {"must_not" : {"bool" : {"should" : {"field" : {"name" : "?"}}}}}}</td> 
  </tr> 
  <tr> 
   <td>Near</td> 
   <td>findByStoreNear</td> 
   <td>Not Supported Yet !</td> 
  </tr> 
  <tr> 
   <td>TRUE</td> 
   <td>findByAvailableTrue</td> 
   <td>{"bool" : {"must" : {"field" : {"available" : true}}}}</td> 
  </tr> 
  <tr> 
   <td>FALSE</td> 
   <td>findByAvailableFalse</td> 
   <td>{"bool" : {"must" : {"field" : {"available" : false}}}}</td> 
  </tr> 
  <tr> 
   <td>OrderBy</td> 
   <td>findByAvailableTrueOrderByNameDesc</td> 
   <td>{"sort" : [{ "name" : {"order" : "desc"} }],"bool" : {"must" : {"field" : {"available" : true}}}}</td> 
  </tr> 
 </tbody> 
</table>