Option to remove duplicate results ?

[alaouy]

Is there an option to remove duplicate results ?

[bigtunacan]

@alaouy For something like that you should filter using a scope and then use the autocomplete scopes option.

[lingceng]

I tried to remove duplicate results with a scope but failed.

Here's my case:

name	category
Jack	A
Jack	B
Tom	A
Jim	B
Tom	C

I want autocompleting for all names but I do not want duplicated names.

I used distinct.

class Consult::Option < ActiveRecord::Base
  scope :no_dup, -> { distinct }
end

class Admin::CaseSearchesController < Admin::AdminController
  autocomplete :option, :name, full: true, class_name: 'Consult::Option', scopes: [:no_dup]
end

But it generate SQL like following:

SELECT  DISTINCT consult_options.id, consult_options.name FROM `consult_options` WHERE `consult_options`.`deleted_at` IS NULL AND (LOWER(consult_options.name) LIKE '%qin%')  ORDER BY LOWER(consult_options.name) ASC LIMIT 10

Anyone can help?

[lingceng]

I end up with a patch to ActionController::Base

class ActionController::Base
  # Unique feature for rails-jquery-autocomplete
  def self.autocomplete_uniq(object, method, options = {})
    define_method("autocomplete_#{object}_#{method}") do
      model = (options[:class_name] || object).to_s.camelize.constantize
      sql = model.select("MIN(id) as id, #{method} as label, #{method} as value").group(method).
        where("#{method} like ?", "%#{params[:term]}%").limit(10).to_sql
      data = model.connection.select_all(sql)
      render json: data
    end
  end
end

So I can use following code to query unique result

class Admin::CaseSearchesController < Admin::AdminController
  autocomplete_uniq :option, :name, class_name: 'Consult::Option'
end

[lingceng]

Aha! Maybe I should use 'unscope' or with full_model:true option.
Something like following:

    class Item < ActiveRecord::Base
      scope :uniq_brand, -> { select('MIN(id) as id, brand').group(:brand) }
    end

    class Admin::CaseSearchesController < Admin::AdminController
      autocomplete :item, :brand, full: true, scopes: [:uniq_brand], full_model: true
    end

The implement is a little tricky.
Maybe it's better when scopes can accept a Proc and can override the selects and wheres.
And a option to remove duplicate is useful too.

[lingceng]

I finally add a unique option. So you can just use code like following to query unique result:

 autocomplete :item, :brand, full: true, unique: true

See details here, and change your Gemfile if you can not wait the PR.

 gem 'rails-jquery-autocomplete', github: 'lingceng/rails-jquery-autocomplete'

[alaouy]

@bigtunacan @lingceng I'm using MongoDB, and you can't do distinct on multiple fields in MongoDB, that's why having an option that does that with some kind of filter on the resulting dataset would be very useful.

[bigtunacan]

@alaouy would it be possible to post a basic public sample project illustrating this? It would help me with looking into a solution for this since I have only used Mongo minimally.