ruby-on-rails - SearchKick中条件所在的用户下级功能

Question

@ankane
我如何在searchkick的where条件中使用postgres下函数

我在下面的查询中工作正常

klass.search(@params[:query], fields: [:name,:category_name],where: {or: [[{available_cities_name: "New Yo"},{available_cities_short_name: "NY"}]]}).hits

现在我想使用较低的功能，但语法错误

klass.search(@params[:query],
  fields: [:name,:category_name],
  where: {
    or: [ [
      {"lower(available_cities_name) = ?", "New Yo"},
      {"lower(available_cities_short_name) = ?", "ny"}
    ]]
  }
).hits

我遇到以下语法错误，

SyntaxError: unexpected '}', expecting end-of-input e_cities_name) = ?", "New Yo"},{"lower(available_cities_shor

有人可以告诉我如何在searchkick中使用较低的功能吗？

Answer 1

Elasticsearch没有lower函数。要解决此问题，您可以索引该字段的小写版本并对其进行查询。

def search_data
  {
    available_cities_name: available_cities_name,
    available_cities_name_lower: available_cities_name.downcase
  }
end